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

• iit9006

  Valued Member

  Points: 54

  More actions

  October 16, 2008 at 4:05 am

  #192240

  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.

• Jon Monahan

  SSCertifiable

  Points: 5942

  More actions

  October 16, 2008 at 6:41 am

  #885758

  Raj - thanks for the info. Seems pretty straightforward.