sysfilegroups

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.