Home Forums SQL Server 2005 T-SQL (SS2K5) Modify the index on a table to include ANOTHER column. RE: Modify the index on a table to include ANOTHER column.

  • 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/