how do I create a table in a file group

• Ken Henry

  Newbie

  Points: 2

  More actions

  October 17, 2002 at 9:03 am

  #58544

  I am a student working on sql server and I am trying to set up tables in a file group.

  How do I do This.

• Greg Larsen

  SSC-Insane

  Points: 20961

  More actions

  October 17, 2002 at 9:45 am

  #438791

  Try:

  Create table <table name> (....) on <filegroup>

  Hope this helps.

  Gregory Larsen, DBA

  If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

  Gregory A. Larsen, MVP

• Rodrigo Acosta

  SSC-Insane

  Points: 21261

  More actions

  October 17, 2002 at 4:03 pm

  #438826

  If you already created them, then you can move the tables to another filegroup. The fastest way is through EM in designing the table.