| title | sys.filegroups (Transact-SQL) | Microsoft Docs | ||||
|---|---|---|---|---|---|
| ms.custom | |||||
| ms.date | 2016-05-24 | ||||
| ms.prod | sql-non-specified | ||||
| ms.reviewer | |||||
| ms.suite | |||||
| ms.technology |
|
||||
| ms.tgt_pltfrm | |||||
| ms.topic | language-reference | ||||
| f1_keywords |
|
||||
| dev_langs |
|
||||
| helpviewer_keywords |
|
||||
| ms.assetid | 9e851f72-1f8e-4515-a25d-152ebc12ed56 | ||||
| caps.latest.revision | 54 | ||||
| author | BYHAM | ||||
| ms.author | rickbyh | ||||
| manager | jhubbard |
[!INCLUDEtsql-appliesto-ss2008-all_md]
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 | Applies to: [!INCLUDEssNoVersion] ([!INCLUDEssSQL15] through current version). 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.