Contains one row for each procedure, view, or table that is referenced by a procedure, view, or trigger.
| Column | Datatype | Description |
|---|---|---|
| id | int | Object ID. |
| number | smallint | Procedure number. |
| depid | int | Dependent object ID. |
| depnumber | smallint | Dependent procedure number. |
| depdbid | smallint | Reserved. |
| depsiteid | smallint | Reserved. |
| status | smallint | Internal status information. |
| 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. |
sysdepends clustered, ignore duplicate key, unique on id, number, depid, depnumber, depdbid, depsiteid
| sp_depends | sp_rename |