sysslices

Applies to all databases. sysslices contains one row for each slice (page chain) of a sliced table. sysslices is used only during the SAP ASE upgrade process. After the upgrade is complete, all the data is removed.

Note: In versions of SAP ASE earlier than 15.0 syspartitions stored partition-related information. This has been renamed to sysslices for SAP ASE 15.0, and later; syspartitions now refers to the catalog that tracks all partition-related data in the SAP ASE server.

Columns

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

Indexes

Unique clustered index on id, partitionid