sysobjects  syspartitions

Chapter 1: System Tables

syspartitionkeys

All databases

Description

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

Columns

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

Indexes





Copyright © 2005. Sybase Inc. All rights reserved. syspartitions

View this book as PDF