Previous Topic: -563 - INVALID ORDER: <aaa>---USE 'ASC' OR 'DESC'Next Topic: -565 - HEX LITERALS MUST HAVE EVEN NUMBER OF HEX DIGITS: xxx

SQL Codes › SQL Return Codes -1 through -999 › -564 - ONLY ONE PRIMARY KEY MAY BE DEFINED

-564 - ONLY ONE PRIMARY KEY MAY BE DEFINED

Explanation

You are attempting to define a second PRIMARY KEY for a table. Only one PRIMARY KEY is allowed per table.

The SQLSTATE that equates to this SQL return code is 42889.

User Response

Remove the duplicate PRIMARY KEY clause from your CREATE TABLE or ALTER TABLE statement.