Modify Columnstore Key

Is there a way to modify the Columnstore Key without dropping the table?

I’ve tried ALTER TABLE <table_name> MODIFY KEY SET (…) sentense that is detailed in this documentation: ALTER TABLE

but it doesn’t work.



You can DROP and ADD columnstore secondary keys via ALTER DROP KEY or ALTER ADD KEY.

You can’t modify a SORT KEY (or CLUSTERED COLUMNSTORE KEY) via ALTER TABLE table. This requires dropping and recreating the table. We have a feature request open for enabling this.


1 Like