Moving Tables

[Todd]

How do you move an existing table from one filegroup to another?

[Jim Tottser]

from BOL:

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.


------------
Todd at 12/8/99 12:18:56 PM


How do you move an existing table from one filegroup to another?