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

Indexes

Unique clustered index On id, number, depid, depnumber