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; 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; then click Properties.
5. In the Table file list, on the Tables tab, select the filegroup to place the table on.
6. Optionally, in the Text file list, select a filegroup on which to place any text, image, and ntext columns.

See Also

Placing Tables on Filegroups