iAnywhere.com - Cannot delete or rename a column referenced in a trigger definition

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 delete or rename a column referenced in a trigger definition

Item	Value
Constant	SQLE_COLUMN_IN_TRIGGER
ODBC 2 State	ERROR
ODBC 3 State	ERROR
Severity	15
SQLCODE	-269
SQLSTATE	53W06
Sybase error code	102

Probable cause

You attempted to delete or rename a column referenced in a trigger definition. Drop the trigger before performing the ALTER statement.