ALTER TABLE MOVE TO

Hi All !

Does anybody knows why doesn't work this ?

ALTER TABLE dbo.MyTable1 MOVE TO MyFileGroup1.

Thx. DBT.

Is that valid syntax?

Looks like the move is a drop clustered constraint option.

Try building a clustered index on the filegroup then dropping it.

|||

I don't know that this is valid syntax.

I don't want to alter any column.

I don't want to alter any constraint.

I want to move the table to another Filegroup.

|||The way to move a table to another filegroup is to (re)build the clustered index with the new filegroup specified.

WesleyB

Visit my SQL Server weblog @. http://dis4ea.blogspot.com

|||

The Problem same here ...

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1768940&SiteID=1

And the solution not works

ALTER TABLE MyTable1 DROP CONSTRAINT PK_MyTable1_xxxxx WITH (MOVE TO 'FileGroup1')

because this constraint referenced by another table(s).