Dynamic Creation of Indexes

• benloe

  Grasshopper

  Points: 11

  More actions

  June 13, 2003 at 6:18 pm

  #81834

  I'm looking for a Script that can search through the system tables and identify the indexes (which I've been able to do) and the indexed fields (which I have not been able to do). I'll use this information to build a script that will dynamically build the drop and create statements for each index for a give datababase.

• mccork

  SSC-Insane

  Points: 22288

  More actions

  June 14, 2003 at 2:23 am

  #461405

  An option is to extend Umachandar's SQLDMO table scripting example at http://www.umachandar.com/technical/SQL70Scripts/UtilitySPs/Main17.htm. Using it as the basis, extend it down to the index level and let SQLDMO generate your scripts.

  Saves reinventing the wheel.

  
  Cheers,
  - Mark

• 5409045121009-7368

  SSCoach

  Points: 15740

  More actions

  June 15, 2003 at 5:52 pm

  #461449

  Do you have another reference to the article

• mccork

  SSC-Insane

  Points: 22288

  More actions

  June 15, 2003 at 8:49 pm

  #461454

  Damn full stops.

  Try: http://www.umachandar.com/technical/SQL70Scripts/UtilitySPs/Main17.htm

  
  Cheers,
  - Mark

• mccork

  SSC-Insane

  Points: 22288

  More actions

  June 15, 2003 at 8:50 pm

  #461456

  Damn full stops.

  Try: http://www.umachandar.com/technical/SQL70Scripts/UtilitySPs/Main17.htm

  
  Cheers,
  - Mark

• 5409045121009-7368

  SSCoach

  Points: 15740

  More actions

  June 15, 2003 at 10:10 pm

  #461460

  Sorry should have noticed, but thanks!