In this blog post, you’ll learn more about the Sybase Error Cannot alter a column in an index and the reason for receiving this error
Sybase SQL Error Message
Cannot alter a column in an index
Reason for this Error
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.