Post reply

Move table to different filegroup

  • December 4, 2009 at 3:11 am

    #1087555

    hi all

    i have a question, how do you transfer a table to a new filegroup but the table is being referenced by another table and it has a foreign key constraint.

    thanks!

  • June 7, 2010 at 11:02 am

    #1177152

    Drop the FK first, move your PK to the new FILEGROUP, recreate the FK.

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply