sysdepends

All databases

Description

sysdepends contains one row for each procedure, view, or table that is referenced by a procedure, view, or trigger.

Columns

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.

Indexes