sysprocedures

All databases

Description

sysprocedures contains entries for each view, default, rule, trigger, procedure, declarative default, and check constraint. The plan or sequence tree for each object 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 12-15)
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 non-procedure entries)
version	int

Table 12-15 lists the bit representations for the type column.

**Table 12-15: 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, type, sequence, number