Contains dependency information between objects (views, procedures, and triggers), and the objects (tables, views, and procedures) contained in their definition. This table is stored in each database.
Column name | Data type | Description |
---|---|---|
id | int | Object ID. |
depid | int | Dependent object ID. |
number | smallint | Procedure number. |
depnumber | smallint | Dependent procedure number. |
status | smallint | Internal status information. |
depdbid | smallint | Reserved. |
depsiteid | smallint | Reserved. |
selall | bit | On if the object is used in a SELECT * statement. |
resultobj | bit | On if the object is being updated. |
readobj | bit | On if the object is being read. |