| |
- Causa
- column-name é um nome de coluna duplicada.
The CREATE INDEX, CREATE TABLE, CREATE VIEW or ALTER TABLE statement specifies the same column-name for two (or more) columns of the index,
table, view, or the UPDATE OF clause of a trigger definition specifies the same column name more than once.
Column names must be unique within an index, a table, a view, or in the UPDATE OF clause of a trigger definition.
A column cannot be specified in more than one ALTER TABLE clause except if it is specified in an ALTER COLUMN clause and ADD CHECK CONSTRAINT clause.
- Ação do sistema
- The statement cannot be executed.
The specified index, table, view, or trigger was not created.
- Resposta ao Desenvolvedor
- Correct the CREATE statement to specify unique names for each of the columns of the index, table, view, or the columns in the UPDATE OF clause of
a trigger definition.
Correct the ALTER statement to specify unique names for each of the ALTER COLUMN clauses.
This error can also occur on CREATE TABLE when a column list of a PRIMARY KEY, FOREIGN KEY, or UNIQUE clause contains two or more occurrences of
the same column name.
SQLSTATE: 42711
© Copyright IBM Corp.
|
| |
