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
Copyright © 2005. Sybase Inc. All rights reserved. |