sysdepends
SQL Server 2000
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. |
