| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys.destination_data_spaces (Transact-SQL) |
sys.destination_data_spaces (Transact-SQL) |
rwestMSFT |
randolphwest |
05/03/2021 |
sql |
system-objects |
reference |
|
|
|
[!INCLUDE SQL Server]
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. For partitioned tables, this can be joined to data_space_id in sys.partition_schemes. |
| 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. |
Requires membership in the public role. For more information, see Metadata Visibility Configuration.