Error 127

"Cannot alter a column in an index"

Item Description

SQLCode

-127L

Constant

COLUMN_IN_INDEX

SQLState

53W05

ODBC 2 State

ERROR

ODBC 3 State

ERROR

Sybase Error Code

2059

Severity Code

16

Probable cause

You may have attempted to delete or modify the definition of a column that is part of a primary or foreign key. You may have attempted to delete a column that has an index on it. In this case, DROP the index or key, perform the ALTER statement, and then add the index or key again.


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