SQL Server 2005 Books Online (November 2008)
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.
|
See Also