Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » Error Messages » SQL Anywhere error messages » SQL Anywhere error messages sorted by message text (T-Z)

 

Table '%1' has no primary key

Error constant SQLE_NO_PRIMARY_KEY
ODBC 2 State 42000
ODBC 3 State 42000
Parameter 1 Name of the table that does not have a primary key.
Severity 16
SQLCODE –118
SQLSTATE 55008
Sybase error code 1719
Probable cause

You attempted an operation that required the referenced table to have a primary key. Examples of these operations include adding a foreign key, or using the ON EXISTING clause of an INSERT statement, while referring to a table that does not have a primary key. You must add a primary key to the referenced table.