title: "sys.data_spaces (Transact-SQL) | Microsoft Docs" ms.custom: "" ms.date: "03/17/2017" ms.prod: "sql" ms.prod_service: "database-engine, sql-data-warehouse, pdw" ms.service: "" ms.component: "system-catalog-views" ms.reviewer: "" ms.suite: "sql" ms.technology:
- "database-engine" ms.tgt_pltfrm: "" ms.topic: "language-reference" f1_keywords:
- "data_spaces"
- "sys.data_spaces_TSQL"
- "sys.data_spaces"
- "data_spaces_TSQL" dev_langs:
- "TSQL" helpviewer_keywords:
- "sys.data_spaces catalog view" ms.assetid: f39d55fe-2c0f-472d-a77f-cebc6fea95b5 caps.latest.revision: 34 author: "edmacauley" ms.author: "edmaca" manager: "craigg" ms.workload: "Inactive" monikerRange: ">= aps-pdw-2016 || = azure-sqldw-latest || >= sql-server-2016 || = sqlallproducts-allversions"
[!INCLUDEtsql-appliesto-ss2008-xxxx-asdw-pdw-md]
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: [!INCLUDEssSQL14] through [!INCLUDEssCurrent]. PS = Partition scheme |
| type_desc | nvarchar(60) | Description of data space type: FILESTREAM_DATA_FILEGROUP MEMORY_OPTIMIZED_DATA_FILEGROUP Applies to: [!INCLUDEssSQL14] through [!INCLUDEssCurrent]. 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: [!INCLUDEssSQL11] through [!INCLUDEssCurrent]. 1 = Data space is used for full-text index fragments. 0 = Data space is not used for full-text index fragments. |
Requires membership in the public role. For more information, see Metadata Visibility Configuration.
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)