How to place an existing table on a different filegroup (Enterprise Manager)

How to place an existing table on a different filegroup (Enterprise Manager)

To place an existing table on a different filegroup

1. Expand a server group, and then expand a server.
   
   
2. Expand Databases, expand the database in which the table belongs, and then click Tables.
   
   
3. In the details pane, right-click the table, and then click Design Table.
   
   
4. Right-click any column, and then click Properties.
   
   
5. On the Tables tab, in the Table Filegroup list, select the filegroup on which to place the table.
   
   
6. Optionally, in the Text Filegroup list, select a filegroup on which to place any text, image, and ntext columns.

See Also

Placing Tables on Filegroups