CHAPTER 10 Database Error Messages
885
Table cannot have two primary keys
Item Value
SQLCODE -126
Constant SQLE_PRIMARY_KEY_TWICE
SQLSTATE 52W05
Sybase error code 1923
ODBC 2 State 42000
ODBC 3 State 42000
You specified the primary key twice in a CREATE TABLE statement.
Table in use
Item Value
SQLCODE -214
Constant SQLE_TABLE_IN_USE
SQLSTATE 42W21
Sybase error code 3702
ODBC 2 State 40001
ODBC 3 State 40001
You attempted to ALTER or DROP a table that is being used by other active
users of the database.
Table must be empty
Item Value
SQLCODE -116
Constant SQLE_TABLE_MUST_BE_EMPTY
SQLSTATE 55W02
Sybase error code 4901
ODBC 2 State ERROR
ODBC 3 State ERROR
Probable cause
Probable cause
To Next Page
Loading...