FileGroup

i understand that the filegroup for a table can be specified in the CREATE Table statement. just out of curiosity, is there any way to move a table to a different filegroup, that too, if the table contains data.i understand that the filegroup for a table can be specified in the CREATE Table statement. just out of curiosity, is there any way to move a table to a different filegroup, that too, if the table contains data.

The only way that I know how to do this is to create a new table, move the data from your existing table to the new table, drop the old table and then rename the new table.

Regards,

hmscott|||Create (or recreate) a clustered index on the new filegroup. Once you've done that, recreate any indicies for that table on the new filegroup too. If you've created a clustered index where none existed (just to move the data), you should then drop that index.

-PatP