All databases
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.
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.
Decimal |
Hex |
Status |
---|---|---|
1 |
0x1 |
Entry describes a plan (reserved) |
2 |
0x2 |
Entry describes a tree |
Unique clustered index on id, number, type, sequence
Copyright © 2005. Sybase Inc. All rights reserved. |