Altering a non clustered index in a sybase

Question

I have a unique non-clustered index on a sybase table which includes 4 columns: col1, col2, col3 and col4.

I want to drop one of the columns from the table.

I don't want to drop and recreate the index.

Can I alter the index to not consider this column?

Answer 1

Shortly no.

You can only alter "database", "role" or "table" in sybase. With using "alter table" you can modify only columns.

Adding or removing a column to index causes an index to be re-created. Sybase doesn't like "modify" something if it has to be re-created so you have to drop and create the index.