Error 118

"Table '%1' has no primary key"

Item Description

SQLCode

-118L

Constant

NO_PRIMARY_KEY

SQLState

55008

ODBC 2 State

42000

ODBC 3 State

42000

Sybase Error Code

2055

Severity Code

16

Parameter 1

Name of the table that does not have a primary key.

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.


Created April 27, 2010. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com