Post reply

Script to get all the indexes associated with the table

  • December 9, 2008 at 8:58 pm

    #125564

    Hi there,

    I have a table which has 10 indexes (1 clustered 9 non-clustered) i also have the same table in another DB

    i need to copy all the indexes to that table as well.

    using GUI i can select the indexes and create a script but i have to do it 1 by 1 (no multiple selection)

    i have to do the same thing for 10 other tables. its so painfull to do it 1 by 1

    can u help me in getting all the indexes associated with 1 table

    Cheers

    GB

  • December 9, 2008 at 9:26 pm

    #910053

    You can select a table and script out everything for that table. Right click the table and select Generate Script.

  • December 9, 2008 at 10:07 pm

    #910067

    hi did indexes r not coming part of the script

  • December 9, 2008 at 10:19 pm

    #910072

    Hi all

    i found the trick click on the indexes folder and then keep ur "object explorer details" window open then u can select multiple indexes and generate a script

    Cheers

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

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