syspartitionkeys

All databases

syspartitionkeys contains one row for each partition key for hash, range, and list partitioning of a table. All columns are not null.

The columns for syspartitionkeys are:

Name	Datatype	Description
indid	smallint	Type of index. Values are: 0 = table 1 = clustered index >1 = nonclustered index
id	int	Object ID of the partitioned table
colid	smallint	Column ID of the partition key of the partitioned table
position	smallint	Position of key among key positions