Question Re: Create table with a primary key constraint in Technology Q&A

Create table with a primary key constraint

Former Member — Mon, 08 Apr 2013 14:46:42 GMT

Hello Guys,

I am trying to execute a MS SQL query like:

CREATE TABLE XYZ

(

"ROLLNO" CHAR(2) NOT NULL,

"SNO" CHAR(20) NOT NULL,

CONSTRAINT ABC_100 PRIMARY KEY ("ROLLNO", "SNO")

);

In Hana DB, but the query fails with following error:

Could not execute 'CREATE TABLE XYZ ( "ROLLNO" CHAR(2) NOT NULL, "SNO" CHAR(20) NOT NULL, CONSTRAINT ABC_100 PRIMARY ...' in 3 ms 703 µs . SAP DBTech JDBC: [257] (at 118): sql syntax error: incorrect syntax near "ABC_100": line 5 col 14 (at pos 118)

Went through the documentation but not able to figure out correct way to run such a query here. Please help.

Best regards,

Dhaval

Re: Create table with a primary key constraint

Ravi_Channe — Mon, 08 Apr 2013 15:01:05 GMT

Hi Dhaval,

Can you please try any of the following:

CREATE TABLE XYZ

(

"ROLLNO" CHAR(2) NOT NULL,

"SNO" CHAR(20) NOT NULL,

PRIMARY KEY ("ROLLNO", "SNO")

);

OR

CREATE TABLE XYZ

(

"ROLLNO" CHAR(2) NOT NULL,

"SNO" CHAR(20) NOT NULL

);

ALTER TABLE XYZ ADD CONSTRAINT ABC_100 PRIMARY KEY ("ROLLNO", "SNO");