| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | monikerRange | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys.data_spaces (Transact-SQL) |
sys.data_spaces (Transact-SQL) |
rwestMSFT |
randolphwest |
03/17/2017 |
sql |
system-objects |
reference |
|
|
|
>=aps-pdw-2016||=azure-sqldw-latest||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current||=fabric |
[!INCLUDE sql-asdbmi-asa-pdw-fabricse-fabricdw]
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] and later. PS = Partition scheme |
| type_desc | nvarchar(60) | Description of data space type: FILESTREAM_DATA_FILEGROUP MEMORY_OPTIMIZED_DATA_FILEGROUP Applies to: [!INCLUDEssSQL14] 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: [!INCLUDEssSQL11] and later. 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)