sysfilegroups

Transact-SQL Reference

Transact-SQL Reference

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.