syssessions  syssrvroles

Chapter 1: System Tables

sysslices

All databases

Description

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.

NoteIn 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.

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





Copyright © 2005. Sybase Inc. All rights reserved. syssrvroles

View this book as PDF