.png)
sys.filegroups (Transact-SQL)
SQL Server 2005
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. |
