cancel
Showing results for 
Search instead for 
Did you mean: 

Error while creating constraint in MaxDB

former_member214651
Active Contributor
0 Kudos

Hi All,

I am getting the following error when I try to add a constraint to my table created in MaxDB. Below are the Query and the Error message:

Query:


CREATE TABLE "SAMPLE"."MULTILINGUAL_TABLE" (
                        "MANUFACTURER" VARCHAR (50) ASCII NOT NULL,
                        "PRODUCTNAME" VARCHAR(50)  ASCII NOT NULL,
                        "MATERIALNUMBER" VARCHAR(50) ASCII NOT NULL,
                        "MATERIALDESC" VARCHAR(50) ASCII NOT NULL,
                        "SYNONYM_NAME" VARCHAR(50) ASCII NOT NULL)
 
ALTER TABLE "SAMPLE"."MULTILINGUAL_TABLEu201D ADD CONSTRAINT "PK_MULTILINGUAL_TABLE" PRIMARY KEY ("MANUFACTURER","PRODUCTNAME","MATERIALNUMBER","MATERIALDESC","SYNONYM_NAME")

Error:


Error Executing 'ALTER TABLE "SAMPLE"."MULTILINGUAL_TABLEu201D ADD CONSTRAINT "PK_MULTILINGUAL_TABLE" PRIMARY KEY ...' [-5015] (at 58): Missing keyword:MODIFY,COLUMN,ADD,DROP,UPDATE,TYPE,SAMPLE,PACKED,NOT,NOCACHE,FOREIGN,FOR,FACT,DYNAMIC,DIMENSION,CLUSTER ...

Please let me know how to create a constraint in MaxDB?

Regards,

Poojith MV

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos