CHAPTER 10 Database Error Messages
881
Table ’%1’ has a foreign key with a referential action
Item Value
SQLCODE -677
Constant SQLE_TABLE_HAS_REFACTION
SQLSTATE 56001
Sybase error code 547
ODBC 2 State ERROR
ODBC 3 State ERROR
Parameter 1 Name of the table with the referential action
The table could not be renamed as it has a foreign key with a referential
action. To rename the table, first drop the foreign key constraints.
Table ’%1’ has no primary key
Item Value
SQLCODE -118
Constant SQLE_NO_PRIMARY_KEY
SQLSTATE 55008
Sybase error code 1719
ODBC 2 State 42000
ODBC 3 State 42000
Parameter 1 Name of the table that does not have a primary key.
You attempted to add a foreign key referring to a table that does not have a
primary key. You must add a primary key to the referenced table.
Probable cause
Probable cause
To Next Page
Loading...