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 |