| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | monikerRange | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys.filegroups (Transact-SQL) |
sys.filegroups (Transact-SQL) |
rwestMSFT |
randolphwest |
05/24/2016 |
sql |
system-objects |
reference |
|
|
|
>=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current||=fabric |
[!INCLUDE sql-asdb-asdbmi-asa-pdw-fabricse-fabricdw]
Contains a row for each data space that is a filegroup.
| Column name | Data type | Description |
|---|---|---|
| <inherited columns> | -- | For a list of columns that this view inherits, see sys.data_spaces (Transact-SQL). |
| filegroup_guid | uniqueidentifier | GUID for the filegroup. NULL = PRIMARY filegroup |
| log_filegroup_id | int | [!INCLUDEssInternalOnly] In [!INCLUDEssNoVersion], the value is NULL. |
| is_read_only | bit | 1 = Filegroup is read-only. 0 = Filegroup is read/write. |
| is_autogrow_all_files | bit | [!INCLUDE SQL Server 2016 and later]. 1 = When a file in the filegroup meets the autogrow threshold, all files in the filegroup grow. 0 = When a file in the filegroup meets the autogrow threshold, only that file grows. This is the default. |
Requires membership in the public role. For more information, see Metadata Visibility Configuration.