Home Forums SQL Server 2005 T-SQL (SS2K5) Adding an include to an existing Index RE: Adding an include to an existing Index

  • May 23, 2013 at 9:51 am

    #1617906

    mister.magoo (5/23/2013)

    I don't have 2005 any more, but interestingly on 2012 at least, you can just issue a CREATE INDEX using the same index name without dropping it first!

    You can in most, if not all versions, by adding the DROP_EXISTING clause to the create index.

    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