ALTER TABLE [INVOICE]
DROP CONSTRAINT [INVOICE_PK] WITH (MOVE TO SECONDERYDATA)
After the move, we now recreate the PK Constraint:
ALTER TABLE [INVOICE]
ADD CONSTRAINT [INVOICE_PK] PRIMARY KEY CLUSTERED
( [column name] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [SECONDERYDATA]
You're specifying the FG name twice. You just need to do this
ALTER TABLE [INVOICE] DROP CONSTRAINT [INVOICE_PK]
ALTER TABLE [INVOICE] ADD CONSTRAINT [INVOICE_PK]
PRIMARY KEY CLUSTERED
(
[column name] ASC
)
WITH (options)
ON [newfilegroup][/CODE]
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉