Create index if not exists

• a2zwd

  SSCrazy

  Points: 2353

  More actions

  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

• SQL Editor

  SSCommitted

  Points: 1980

  More actions

  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