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