DB2 SQL-Error: -539

Short Description: TABLE DOES NOT HAVE A PRIMARY KEY

DB2 cannot perform the CREATE or ALTER TABLE statement because the indicated table does not have a primary key. Thus, the primary key cannot be dropped, or the table cannot be defined as a parent in a referential constraint. System action: The statement cannot be processed. Programmer response: Correct the statement to reference a table with a primary key, or define a primary key with ALTER TABLE ADD PRIMARY KEY before referencing the table in a FOREIGN KEY clause.

 <-  BACK TO INDEX