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.

Discuss this page in DocCommentXchange.
Send feedback about this page using email.