Export (0) Print
Expand All

sys.filegroups (Transact-SQL)

Contains a row for each data space that is a filegroup.

Applies to: SQL Server (SQL Server 2008 through current version).

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.

Requires membership in the public role. For more information, see Metadata Visibility Configuration.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft