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
Reference
Catalog Views (Transact-SQL)
Data Spaces and Full-Text Catalog Views (Transact-SQL)
sys.data_spaces (Transact-SQL)