sys.filegroups (Transact-SQL)
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 |
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. In SQL Server, the value is NULL. |
is_read_only |
bit |
1 = Filegroup is read-only. 0 = Filegroup is read/write. |
Permissions
Requires membership in the public role. For more information, see Metadata Visibility Configuration.