sysdepends

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, including predicated privileges, for compiled objects, and is decoded by sp_depends to report on column-level dependencies for stored procedures, triggers, and views.