How to check table store in which DB file group

  • If I created two files group for my DB.

    1. How to check the table store in which file group?

    2. When I create a new table, how to assign the table to the second file group in DB?

    3. How to move all the table into main file group if I want to delete the second file group in order to maintain one file group for my DB>

  • You can do all of that via Enterprise Manager (EM):

    1) within EM, right-click the table to bring up properties; it will show you which file group the table is stored in.

    2) when you create your table via EM, click on the properties button (next to the save button) and select the table file group.

    3) same as number 2) except you edit the table under the Design view and select the file group from the table properties (when you save your changes, what EM is actually doing is dropping your table and recreating it in the new file group).

  • Thanks !

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

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