Transact-SQL Reference
sysdepends
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. |