Can your just explain the need for "MOVE TO SECONDERYDATA" at the time when we drop"INVOICE

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Raj Gujar » Can your just explain the need for "MOVE TO...

Can your just explain the need for "MOVE TO SECONDERYDATA" at the time when we drop"INVOICE_PK" constrain.

Rate Topic

Display Mode

Topic Options

Author

Message

iit9006

Posted Thursday, October 16, 2008 4:05 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, July 22, 2011 10:23 PM
Points: 2, Visits: 33

ALTER TABLE [INVOICE]
DROP CONSTRAINT [INVOICE_PK] WITH (MOVE TO SECONDERYDATA)

Can your just explain the need for "MOVE TO SECONDERYDATA" at the time when we drop "INVOICE_PK" constrain.

Post #586816

Jon Monahan

Posted Thursday, October 16, 2008 6:41 AM

SSCrazy

Group: General Forum Members
Last Login: Thursday, May 09, 2013 8:38 AM
Points: 2,156, Visits: 99

Raj - thanks for the info. Seems pretty straightforward.

Post #586894

« Prev Topic | Next Topic »

Permissions