SQLServerCentral / SQL Server 2005 / T-SQL (SS2K5) / Modify the index on a table to include ANOTHER column. / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 15:57:24 GMT20RE: Modify the index on a table to include ANOTHER column.http://www.sqlservercentral.com/Forums/Topic732786-338-1.aspxDrop the index, create a new one. Or create the index with the DROP_EXISTING clauseThu, 11 Jun 2009 02:29:43 GMTGilaMonsterRE: Modify the index on a table to include ANOTHER column.http://www.sqlservercentral.com/Forums/Topic732786-338-1.aspxAs 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.AdiThu, 11 Jun 2009 01:10:25 GMTAdi Cohn-120898Modify the index on a table to include ANOTHER column.http://www.sqlservercentral.com/Forums/Topic732786-338-1.aspxI need to modify the unique index already created on a table to include another column.How can i do that?Thu, 11 Jun 2009 00:57:36 GMTsreekirt-1108866