CODEWITHSUNDEEP
sqlsybase
user401574
user401574

Reputation: 571

Altering a non clustered index in a sybase

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?

Upvotes: 0

Views: 2386

Answers (1)

Burcin
Burcin

Reputation: 985

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.

Upvotes: 1

Related Questions