move table to another filegroup

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