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

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

SQL Anywhere 10.0.1 » SQL Anywhere 10 - Error Messages » Database Error Messages » Alphabetic list of error messages

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

Item	Value
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.