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-20)
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 Adaptive Server that created the sequence tree stored in this catalog for a given object

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

**Table 1-20: type control bits in the sysprocedures table**
Decimal	Hex	Status
1	0x1	Entry describes a plan (reserved)
2	0x2	Entry describes a tree

Indexes

Unique clustered index on id, number, type, sequence