-537 THE PRIMARY KEY, FOREIGN KEY, UNIQUE, OR PARTITIONING KEY CLAUSE IDENTIFIES COLUMN `column-name` MORE THAN ONCE

Explanation

PRIMARY KEY, FOREIGN KEY, UNIQUE, or PARTITIONING KEY can each be followed by a list of column names. The statement violates the rule that no column name can appear more than once in any such list.

System action

The statement cannot be processed.

Programmer response

Correct the statement to specify unique names for each column.

SQLSTATE
42709 

-537 THE PRIMARY KEY, FOREIGN KEY, UNIQUE, OR PARTITIONING KEY CLAUSE IDENTIFIES COLUMN column-name MORE THAN ONCE

Explanation

System action

Programmer response

SQLSTATE

-537 THE PRIMARY KEY, FOREIGN KEY, UNIQUE, OR PARTITIONING KEY CLAUSE IDENTIFIES COLUMN `column-name` MORE THAN ONCE