Contents Index Table cannot have two primary keys Table must be empty

ASA Error Messages
  Database Error Messages
    Alphabetic list of error messages

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
Probable cause 

You attempted to ALTER or DROP a table that is being used by other active users of the database.

Contents Index Table cannot have two primary keys Table must be empty