TSQL to add an index

• Nali

  SSCommitted

  Points: 1525

  More actions

  August 18, 2006 at 6:57 am

  #61714

  I need to modify an existing table, to change a field into an index field. I know how to do it through Enterprise Manager. Is there a way to do this through script?

  Thanks...Nali

• stewart noble

  SSCrazy

  Points: 2009

  More actions

  August 18, 2006 at 7:23 am

  #655631

  In it's most basic format:

  create index MyNewIndex on MyTable(MyColumn)

  If you want it to be clustered:

  create clustered index MyClusteredIndex on MyTable(MyColumn)

  if you want it unique:

  create unique index MyUniqueIndex on MyTable(MyColumn)

  If you need any more info then BOL is your friend.

   

  S