sysdepends (T-SQL)

Contains dependency information between objects (views, procedures, and triggers), and the objects (tables, views, and procedures) contained in their definition. This table is stored in each database.

Column name Data type Description
id int Object ID.
depid int Dependent object ID.
number smallint Procedure number.
depnumber smallint Dependent procedure number.
status smallint Internal status information.
depdbid smallint Reserved.
depsiteid smallint Reserved.
selall bit On if the object is used in a SELECT * statement.
resultobj bit On if the object is being updated.
readobj bit On if the object is being read.

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.