Post reply

Extracting Non-clustered indexes

  • May 29, 2007 at 6:11 am

    #68676

    Hi guys

    I'm having a dilemma as to how I can extract only non-clusterd indexes from a database. Can anyone help me here because I know I can generate the DDL but I'm not sure If I can get the non-clustered indexes only from the database. Thanks

  • May 29, 2007 at 7:26 am

    #709337

    Script the table with indexes and then delete the table, clustered index.

  • May 29, 2007 at 7:40 am

    #709346

    I generated the DDL which included everything which made me think there must be a way to generate only the indexes and delete as appropriate.

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

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