sys.data_spaces (Transact-SQL)

Applies to: SQL Server 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. This can be a filegroup, partition scheme, or FILESTREAM data filegroup.

Column name	Data type	Description
name	sysname	Name of data space, unique within the database.
data_space_id	int	Data space ID number, unique within the database.
type	char(2)	Data space type: FG = Filegroup FD = FILESTREAM data filegroup FX = Memory-optimized tables filegroup Applies to: SQL Server 2014 (12.x) and later. PS = Partition scheme
type_desc	nvarchar(60)	Description of data space type: FILESTREAM_DATA_FILEGROUP MEMORY_OPTIMIZED_DATA_FILEGROUP Applies to: SQL Server 2014 (12.x) and later. PARTITION_SCHEME ROWS_FILEGROUP
is_default	bit	1 = This is the default data space. The default data space is used when a filegroup or partition scheme is not specified in a CREATE TABLE or CREATE INDEX statement. 0 = This is not the default data space.
is_system	bit	Applies to: SQL Server 2012 (11.x) and later. 1 = Data space is used for full-text index fragments. 0 = Data space is not used for full-text index fragments.

Permissions

Requires membership in the public role. For more information, see Metadata Visibility Configuration.

See Also

Data Spaces (Transact-SQL)
Catalog Views (Transact-SQL)
sys.databases (Transact-SQL)
sys.destination_data_spaces (Transact-SQL)
sys.filegroups (Transact-SQL)
sys.partition_schemes (Transact-SQL)
Querying the SQL Server System Catalog FAQ
In-Memory OLTP (In-Memory Optimization)