sys.destination_data_spaces (Transact-SQL)

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.

See Also

Reference

Catalog Views (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance