alter table db.schme.table drop move to filegroup1?
this doesnot work
thanks
your syntax looks wrong
try:
altertable dbo.Gladiators
dropconstraint pk_Gladiators_int1
WITH(moveto'filegroup1')
|||In order to move a table to another filegroup, use the statement "create index" with the option "with drop_existing", to recreate the clustered index, and specify the new filegroup. See "create index" in BOL.
AMB
