sys.data_spaces (Transact-SQL)sys.data_spaces (Transact-SQL)

適用範圍:Applies to: 是SQL ServerSQL Server (所有支援的版本) yesSQL ServerSQL Server (all supported versions) 是Azure SQL 受控執行個體Azure SQL Managed InstanceYesAzure SQL 受控執行個體Azure SQL Managed Instance 是Azure Synapse AnalyticsAzure Synapse AnalyticsyesAzure Synapse AnalyticsAzure Synapse Analytics 是平行處理資料倉儲Parallel Data Warehouseyes平行處理資料倉儲Parallel Data Warehouse適用範圍:Applies to: 是SQL ServerSQL Server (所有支援的版本) yesSQL ServerSQL Server (all supported versions) 是Azure SQL 受控執行個體Azure SQL Managed InstanceYesAzure SQL 受控執行個體Azure SQL Managed Instance 是Azure Synapse AnalyticsAzure Synapse AnalyticsyesAzure Synapse AnalyticsAzure Synapse Analytics 是平行處理資料倉儲Parallel Data Warehouseyes平行處理資料倉儲Parallel Data Warehouse

針對每個資料空間,各包含一個資料列。Contains a row for each data space. 這可以是檔案群組、分割區配置或 FILESTREAM 資料檔案群組。This can be a filegroup, partition scheme, or FILESTREAM data filegroup.

資料行名稱Column name 資料類型Data type 描述Description
NAMEname sysnamesysname 資料空間的名稱,它在資料庫中是唯一的。Name of data space, unique within the database.
data_space_iddata_space_id intint 資料空間識別碼,它在資料庫中是唯一的。Data space ID number, unique within the database.
類型type char(2)char(2) 資料空間類型:Data space type:

FG = 檔案群組FG = Filegroup

FD = FILESTREAM 資料檔案群組FD = FILESTREAM data filegroup

FX = 記憶體最佳化的資料表檔案群組FX = Memory-optimized tables filegroup

適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.

PS = 分割區配置PS = Partition scheme
type_desctype_desc nvarchar(60)nvarchar(60) 資料空間類型的描述:Description of data space type:

FILESTREAM_DATA_FILEGROUPFILESTREAM_DATA_FILEGROUP

MEMORY_OPTIMIZED_DATA_FILEGROUPMEMORY_OPTIMIZED_DATA_FILEGROUP

適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.

PARTITION_SCHEMEPARTITION_SCHEME

ROWS_FILEGROUPROWS_FILEGROUP
is_defaultis_default bitbit 1 = 這是預設的資料空間。1 = This is the default data space. 如果 CREATE TABLE 或 CREATE INDEX 陳述式沒有指定檔案群組或分割區區配置,則會使用預設資料空間。The default data space is used when a filegroup or partition scheme is not specified in a CREATE TABLE or CREATE INDEX statement.

0 = 這不是預設的資料空間。0 = This is not the default data space.
is_systemis_system bitbit 適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.

1 = 將資料空間用於全文檢索索引片段。1 = Data space is used for full-text index fragments.

0 = 不將資料空間用於全文檢索索引片段。0 = Data space is not used for full-text index fragments.

權限Permissions

需要 public 角色中的成員資格。Requires membership in the public role. 如需相關資訊,請參閱 Metadata Visibility ConfigurationFor more information, see Metadata Visibility Configuration.

另請參閱See Also

資料空間 (Transact-sql) Data Spaces (Transact-SQL)
目錄檢視 (Transact-SQL) Catalog Views (Transact-SQL)
sys.databases (Transact-SQL) sys.databases (Transact-SQL)
sys.destination_data_spaces (Transact-SQL) sys.destination_data_spaces (Transact-SQL)
sys.filegroups (Transact-SQL) sys.filegroups (Transact-SQL)
sys.partition_schemes (Transact-SQL) sys.partition_schemes (Transact-SQL)
查詢 SQL Server 系統目錄常見問題 Querying the SQL Server System Catalog FAQ
記憶體內部 OLTP (記憶體內部最佳化)In-Memory OLTP (In-Memory Optimization)