| |
- Causa
- TABLE table-name 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.
- Ação do sistema
- The statement cannot be processed.
- Resposta ao Desenvolvedor
- 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.
SQLSTATE: 42888
© Copyright IBM Corp.
|
| |
