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.