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

SQL Anywhere 11.0.0 » Error Messages » SQL Anywhere error messages » SQL Anywhere error messages sorted by message text (A-C)

 

Cannot drop or modify object '%1' because at least one other object ( %2 '%3') depends upon it

Error constant SQLE_OBJECT_HAS_DEPENDENTS
ODBC 2 State 42000
ODBC 3 State 42000
Parameter 1 The name of the object that could not be dropped or modified.
Parameter 2 The type of the object that depends on the object that could not be dropped or modified.
Parameter 3 The name of the object that depends on the object that could not be dropped or modified.
Severity 16
SQLCODE –1037
SQLSTATE 55W16
Sybase error code 13474
Probable cause

You attempted to drop or modify an object, such as a table or a column, that is used by another object, such as a materialized view, that cannot be automatically invalidated. The dependent object must be disabled or dropped before a drop or modification can be permitted.