logo  
Google
 

DB2 SQL-Error: -624

SQLState: 42889

Short Description: TABLE ALREADY HAS A PRIMARY KEY OR UNIQUE KEY CONSTRAINT WITH SPECIFIED COLUMNS

The code is used to report that a primary key or unique key cannot be defined in an ALTER TABLE statement because the table either: v Already has a primary key, or v Has an existing unique constraint with the same definition (same set of columns specified) as the new key.System action: The statement cannot be run. Programmer response: Do not attempt to define a table with more than one primary key, or a unique constraint that duplicates the definition of an existing unique constraint.

 <-  BACK TO INDEX