Applies to 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 |
qp_setting |
varbinary(6) null |
For future use only |
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 SAP ASE that created the sequence tree stored in this catalog for a given object |
The bit representations for the type column are:
Unique clustered index on id, number, type, sequence