Move of indexes

• shahgols

  SSCrazy Eights

  Points: 9874

  More actions

  August 14, 2002 at 3:20 pm

  #158766

  Hello everyone,

  I wanted to know which SQL command to move an index from one filegroup to another. What command(s) do I use? I know how to do it in EM, but I am looking for a command line solution because I have many indexes to move. Thank you.

• Michael S. Armentrout

  Ten Centuries

  Points: 1178

  More actions

  August 15, 2002 at 11:54 am

  #434650

  CREATE INDEX...ON <different filegroup>. Fill in the blanks for all of the indexes you want to move.

  Be great!

  
  Be great!
  Michael