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. |
Permissions
Requires membership in the public role. For more information, see Metadata Visibility Configuration.