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>

  • when you create a table, the default is "ON PRIMARY" for it unless you specify something else. To direct it to your 2nd file group specify "create table ... on secondary" or whatever name you called it.

    from BOL:

    How to place an existing table on a different filegroup (Enterprise Manager)

    To place an existing table on a different filegroup

    Expand a server group, and then expand a server.

    Expand Databases, expand the database in which the table belongs, and then click Tables.

    In the details pane, right-click the table, and then click Design Table.

    Right-click any column, and then click Properties.

    On the Tables tab, in the Table Filegroup list, select the filegroup on which to place the table.

    Optionally, in the Text Filegroup list, select a filegroup on which to place any text, image, and ntext columns.

    to see where it's defined use SP_HELP tablename and it will show where the table is located.

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

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