| |
- Causa
- THE DEFINITION OF TABLE table-name IS INCOMPLETE BECAUSE IT LACKS A PRIMARY INDEX OR A REQUIRED UNIQUE INDEX.
The table named was defined with a PRIMARY KEY clause, a UNIQUE clause, or with a ROWID column with the GENERATED BY DEFAULT attribute.
Its definition is incomplete, and it cannot be used until a unique index is defined for
- the primary key (the primary index)
- a ROWID column
- for each set of columns in any UNIQUE clause (the required unique indexes).
An attempt was made to use the table in a FOREIGN KEY clause or in an SQL manipulative statement.
- Ação do sistema
- The statement cannot be executed.
- Resposta ao Desenvolvedor
- Define a primary index or a required unique index on the table before referencing it.
SQLSTATE: 57001
© Copyright IBM Corp.
|
| |
