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 nameData typeDescription
groupidsmallintGroup identification number unique for each database.
allocpolicysmallintReserved.
statusint0x8 = READ ONLY; 0x10 = DEFAULT
groupnamesysnameName of the filegroup.