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