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.
|
Requires membership in the public role. For more information, see Metadata Visibility Configuration.
Reference
Catalog Views (Transact-SQL)
Help and Information
Getting SQL Server 2008 Assistance