sysfilegroups System Table - SQL Server 2000
Contains one row for each filegroup in a database. This table is stored in each database. There is at least one entry in this table that is for the primary filegroup.
Column name
Data type
Description
groupid
smallint
Group identification number unique for each database.
allocpolicy
smallint
Reserved.
status
int
0x8 = READ ONLY; 0x10 = DEFAULT
groupname
sysname
Name of the filegroup.