| |
- Causa
- TABLE table-name 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:
- Already has a primary key, or
- Has an existing unique constraint with the same definition (same set of columns specified) as the new key.
- Ação do sistema
- The statement cannot be run.
- Resposta ao Desenvolvedor
- 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.
SQLSTATE: 42889
© Copyright IBM Corp.
|
| |
