Jasinski Technical Wiki

Navigation

Home Page
Index
All Pages

Quick Search
»
Advanced Search »

Contributor Links

Create a new Page
Administration
File Management
Login/Logout
Your Profile

Other Wiki Sections

Software

PoweredBy

sysdepends System Table - SQL Server 2000

RSS
Modified on Fri, May 01, 2009, 10:54 AM by Administrator Categorized as SQL Server System Tables
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 nameData typeDescription
idintObject ID.
depidintDependent object ID.
numbersmallintProcedure number.
depnumbersmallintDependent procedure number.
statussmallintInternal status information.
depdbidsmallintReserved.
depsiteidsmallintReserved.
selallbitOn, if the object is used in a SELECT * statement.
resultobjbitOn, if the object is being updated.
readobjbitOn, if the object is being read.

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2018, Patrick Jasinski.