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. |