Error 1037

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

Item Description

SQLCode

-1037L

Constant

OBJECT_HAS_DEPENDENTS

SQLState

55W16

ODBC 2 State

42000

ODBC 3 State

42000

Sybase Error Code

2706

Severity Code

16

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.

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.


Created April 27, 2010. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com