Post reply

Create index if not exists

  • November 25, 2009 at 4:01 am

    #136419

    Hi,

    How can find all the tables in a database where a filed(ex. LastUpdateDate) field exists or not.

    If exists, find any non clustered index already exists or not. If not create one.

    Can anybody get the script?

    thanks

  • November 25, 2009 at 4:12 am

    #1083895

    YOU CAN TAKE INFORMATION BY THESE QUERYs

    select * from information_schema.tables where table_type='base table'

    select * from information_schema.columns where column_name='field name'

    select * from information_schema.KEY_COLUMN_USAGE where column_name='field name'

    Arrange These according your need

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

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

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy