Contains entries for each view, default, rule, trigger, CHECK constraint, DEFAULT constraint, and stored procedure. The plan or sequence tree for each object is stored in binary form. If the sequence tree doesn't fit in one entry, it is put into more than one row. The sequence field identifies the sub-rows.
| Column | Datatype | Description |
|---|---|---|
| type | smallint | Object type: 1 Entry describes a plan (reserved) 2 Entry describes a tree |
| id | int | Object ID. |
| sequence | smallint | Sequence number if more than one row is used to describe this object. |
| status | smallint | Internal system status. |
| number | smallint | Subprocedure number when the procedure is grouped (0 for nonprocedure entries). |
sysprocedures clustered, unique on id, number, type, sequence
| sp_sproc_columns | sp_stored_procedures |