Events
Get certified in Microsoft Fabric—for free!
19 Nov, 11 pm - 10 Dec, 11 pm
For a limited time, the Microsoft Fabric Community team is offering free DP-600 exam vouchers.
Prepare nowThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW) SQL analytics endpoint in Microsoft Fabric Warehouse in Microsoft Fabric
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 | 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. |
is_autogrow_all_files | bit | Applies to:
SQL Server 2016 (13.x) and later versions. 1 = When a file in the filegroup meets the autogrow threshold, all files in the filegroup grow. 0 = When a file in the filegroup meets the autogrow threshold, only that file grows. This is the default. |
Requires membership in the public role. For more information, see Metadata Visibility Configuration.
Events
Get certified in Microsoft Fabric—for free!
19 Nov, 11 pm - 10 Dec, 11 pm
For a limited time, the Microsoft Fabric Community team is offering free DP-600 exam vouchers.
Prepare now