All databases
sysdepends contains one row for each procedure, view, or table that is referenced by a procedure, view, or trigger.
The columns for sysdepends are:
Name |
Datatype |
Description |
---|---|---|
id |
int |
Object ID. |
number |
smallint |
Procedure number. |
depid |
int |
Dependent object ID. |
depnumber |
smallint |
Dependent procedure number. |
status |
smallint |
Internal status information. |
selall |
bit |
On if object is used in select * statement. |
resultobj |
bit |
On if object is being updated. |
readobj |
bit |
On if object is being read. |
columns |
varbinary |
Stores a bitmap of column IDs of columns that are referenced in the body of a stored procedure.This bitmap gives column-level dependency tracking information for compiled objects, and is decoded by sp_depends to report on column-level dependencies for stored procedures, triggers, and views. |
Unique clustered index on id, number, depid, depnumber