Create table with a primary key constraint

[Former Member]

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

[Ravi_Channe]

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");