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.

See Also

Reference

Catalog Views (Transact-SQL)

Data Spaces (Transact-SQL)