sys-destination-data-spaces-transact-sql.md

title	sys.destination_data_spaces (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	06/10/2016
ms.prod	sql
ms.prod_service	database-engine
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	sys.destination_data_spaces destination_data_spaces_TSQL destination_data_spaces sys.destination_data_spaces_TSQL
dev_langs	TSQL
helpviewer_keywords	sys.destination_data_spaces catalog view
ms.assetid	92df932b-ad5c-43f8-81f4-b158823ab189
caps.latest.revision	20
author	edmacauley
ms.author	edmaca
manager	craigg
ms.workload	Inactive

sys.destination_data_spaces (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

Contains a row for each data space destination of a partition scheme.

Column name	Data type	Description
partition_scheme_id	int	ID of the partition-scheme that is partitioning to the data space.
destination_id	int	ID (1-based ordinal) of the destination-mapping, unique within the partition scheme.
data_space_id	int	ID of the data space to which data for this scheme's destination is being mapped.

Permissions

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

See Also

Catalog Views (Transact-SQL)