Export (0) Print
Expand All

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

Reserved for future use. In Microsoft SQL Server 2005, the value is NULL.

is_read_only

bit

1 = Filegroup is read-only.

0 = Filegroup is read/write.

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

Community Additions

ADD
Show:
© 2014 Microsoft