T-SQL for Generating Index script

• Amit Kumar

  SSChasing Mays

  Points: 614

  More actions

  March 4, 2007 at 10:07 pm

  #176207

  Hi

  Anyone guide me how to generate script for index only. I don't want to script table. I need only index script.

  Amit

• MohammedU

  SSCoach

  Points: 19644

  More actions

  March 5, 2007 at 12:13 am

  #693031

  http://www.databasejournal.com/features/mssql/article.php/2205291

  http://www.nigelrivett.net/DMO/DMOScriptAllDatabases.html

   

  MohammedU
  Microsoft SQL Server MVP

• Amit Kumar

  SSChasing Mays

  Points: 614

  More actions

  March 5, 2007 at 3:36 am

  #693049

  Excellent. It works. I've customized it according to my requirement. Thanks a lot.

  Amit