move table to filegroup

Last Post 13 Jan 2009 06:55 PM by dianagele. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
dianagele
New Member
New Member

--
05 Jan 2009 12:48 PM
I am studying the 70-431 & have a question:

if there is an existing table in the main filegroup and want to move it to a second filegroup:

is the only option is to re-script the table and append the existing data?

I looked at the alter table BOL and did nothing jumped out at me.


Thanks in advance!

Regards,
C-
dianagele
New Member
New Member

--
13 Jan 2009 06:55 PM
excellent; then it is dropping are-creating for me...


Acceptable Use Policy
---