Post reply

move the table from one filegroup to another file group

  • May 27, 2009 at 2:25 am

    #99698

    Hi ,

    i created the table in my database under filegroup called primary ,now i want to move that table to another filegroup in the database called 'data01' and move the primary key constraint to filegroup 'index01'.

    if i create unique index on one file group ,if i want to change that file group i can goto the storage of the index and changed its working fine but its not possible to change for primary key constraint .

    please help me to change the file group for table and file group for primary key constraint .

    Thanks for advance,

    Regards,

    Ramana.

  • May 27, 2009 at 9:29 am

    #1000735

    Hi,

    I assume Primary Key index is a clustered index.

    Clustered index the data rows sorted themselves. Table storage and clustered primary key index cannot be in different file group, considering its design principle.

    You can first drop the primary key constraint with a move option and recreate it specifying the destination file group name. In turn table will be moved to destination file group.

    Please let me know, it doesn't make sense.

    Thank you,

    Prileep

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

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