Listing Tables and Indexes

  • Comments posted to this topic are about the item Listing Tables and Indexes

  • Can someone tell me how to rename all DEV tables and it's indexes to LIVE nomenclature? Ex: ProductsDev to ProductsLive and all indexes renamed to Live extension as well.

    Here is a query selecting what DEV tables and their indexes. I just need to put it in a loop for rename. Doing so keeps naming conventions correct and makes a generic method so if indexes are added sql code doesn't have to be maintained.

    Any help is greatly appreciated.

    /* Loop through all DEV tables and it's indexes */

    SELECT 'Table', 'Index'

    FROM sysindexes a, sysobjects b

    WHERE =

    and like '%Dev'

    and ( like 'PK%' or like 'IX%')

    and b.type = 'U'

    and indid NOT IN (0, 255)

    order by

  • Thanks for the script.

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

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