All databases
syspartitions contains one row for each partition (page chain) of a partitioned table.
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 |
