Post reply

Drop and recreate Index

  • February 6, 2007 at 5:45 am

    #175060

    Hi All,I am working in an Assignment in which we need to alter the width of a column from char(10) to varchar(15). and the said column is participating in the indexes created for the tableNow the approach what we are doing is,Drop the IndexAlter the tableRecreate the IndexNow assume that there is a SP called "Getdata" which refers this table and is it required for me to re_compile the SP;s referring this table that underwent the column change.Please help me out

  • February 6, 2007 at 5:54 am

    #687996

    All objects refferencing that table will be recompiled.

  • February 6, 2007 at 11:44 pm

    #688200

    You also don't need to drop and recreate an index when you alter a column.

    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

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

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