| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys.sysfilegroups (Transact-SQL) |
sys.sysfilegroups (Transact-SQL) |
rwestMSFT |
randolphwest |
03/15/2017 |
sql |
system-objects |
reference |
|
|
|
[!INCLUDE SQL Server]
Contains one row for each file group in a database. There is at least one entry in this table that is for the primary file group.
Important
[!INCLUDEssnoteCompView]
| 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 file group. |
Mapping System Tables to System Views (Transact-SQL)
Compatibility Views (Transact-SQL)