Dropping Indexes after comparing Index Definition

  • Hello,

    I need to update all the indexes in my database through C# installer. I am using below queries to drop each index and then recreate them.

    if exists (select * from sysindexes where name='IX_Oetype')

    DROP INDEX orderlines.IX_Oetype

    But it is taking too much time to update the indexes.

    Is there is any other query by which I can compare if any change in index definition [ Sequence of columns changed, new column added ...etc] then update else not.

    or any other suggestion??

    Thanks

    Manissha

Viewing 0 posts

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