Modify the index on a table to include ANOTHER column.

Question

Modify the index on a table to include ANOTHER column.

sreekirt-1108866

SSC Journeyman

Points: 80
More actions
June 11, 2009 at 12:57 am

#133157

I need to modify the unique index already created on a table to include another column.
How can i do that?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Adi Cohn-120898 SSC-Dedicated Points: 33944 More actions · Answer 1

As far as I know you can't use alter index statement to modify the columns that the index is referencing. You'll have to create a new index with the included column and then drop the old one.

Adi

--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

Drop the index, create a new one. Or create the index with the DROP_EXISTING clause

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass