syspartitions

All databases

Description

syspartitions contains one row for each partition (page chain) of a partitioned table.

Columns

The columns for syspartitions are:

Name

Datatype

Description

state

smallint

Internal information about the state of the partition

id

int

Object ID of the partitioned table

partitionid

int

Partition ID number

firstpage

int

Page number of the partition’s first page

controlpage

int

Page number of the partition’s control page

spare

binary(32)

Reserved

Indexes

Unique clustered index On id, partitionid