All databases
sysslices contains one row for each slice (page chain) of a sliced table. sysslices is used only during the Adaptive Server upgrade process. After the upgrade is complete, all the data is removed.
In versions of Adaptive Server earlier than 15.0 syspartitions was
the name of the catalog that stored partition-related information.
This has been renamed to sysslices for Adaptive
Server 15.0, with syspartitions now referring to
the catalog that tracks all partition-related data in
Adaptive Server.
The columns for sysslices 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 |
Unique clustered index on id, partitionid
