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

SQL Anywhere 10.0.1 » SQL Anywhere 10 - Error Messages » Database Error Messages » Alphabetic list of error messages

Table '%1' has a foreign key with a referential action Next Page

Table '%1' has no primary key


Item

Value

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.