Post reply

ALTER table when field is indexed

  • May 21, 2007 at 10:09 am

    #178598

    i am trying to modify the data type of a field that is used in a index, i get a syntax error

    Do i have to explicitely drop the indexes and the constraints before???? isn't there some syntax to drop automatically then rebuild after alter?

    i really have LOTS of fields to change in that script; i don't want to add ALTER index to each table i have!

    tx for the help!

  • May 21, 2007 at 11:01 am

    #707877

    Use EM / SSIS or drop the objects then rebuild. (you may use the EM to see what script must created, then copy paste so that you can run it when ready)

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

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