Export (0) Print
Expand All
Expand Minimize

sysdepends

SQL Server 2000

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft