syspartitions  sysprocesses

Chapter 1: System Tables

sysprocedures

All databases

Description

sysprocedures contains entries for each view, default, rule, trigger, procedure, declarative default, partition condition, check constraint, comuted column, function-based index key, and other forms of compiled objects. The sequence tree for each object, including computed columns or function-based index definition, is stored in binary form. If the sequence tree does not fit into one entry, it is broken into more than one row. The sequence column identifies the sub-rows.

Columns

The columns for sysprocedures are:

Name

Datatype

Description

type

smallint

Object type (see Table 1-18)

id

int

Object ID

sequence

int

Sequence number if more than one row is used to describe this object

status

smallint

Internal system status

number

smallint

Sub-procedure number when the procedure is grouped (0 for nonprocedure entries)

version

int null

The version of Adaptive Server that created the sequence tree stored in this catalog for a given object

Table 1-18 lists the bit representations for the type column.

Table 1-18: type control bits in the sysprocedures table

Decimal

Hex

Status

1

0x1

Entry describes a plan (reserved)

2

0x2

Entry describes a tree

Indexes





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

View this book as PDF