Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2002
    Location
    BH - MG - BRAZIL
    Posts
    13

    Unanswered: filegroup's table

    Hi!!!

    I would like to know what filegroup is in the table or what tables are in the filegroup, using SELECT.

    Excume my english.

    Thank you.

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    May check DBCC CHECKFILEGROUP which returns part of information required.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Oct 2001
    Location
    England
    Posts
    426
    It is found in sysindexes.
    The data pages will be id = 0 if no clustered index or 1 if there is a clustered index.

    groupid will give the filegroup id.

    You can find the filegroup corresponding to the groupid in sysfiles.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •