Discussion in 'SQL Server 2005 General Developer Questions' started by Ruksharr, Apr 28, 2008.
Can anybody show that how can we create table on a secondary file group and move it to primary ?
To create you have to use ON option in CREATE TABLE. Of course you have to create secondary file group first.
For the second part, severals options.
For instance, if the table have cluster index, just move cluster to primary. Or script the table and modify to primary.
Now,why you just create in primary in first place?
Separate names with a comma.