sys-sysdepends-transact-sql.md

title	sys.sysdepends (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/15/2017
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
f1_keywords	sys.sysdepends_TSQL sysdepends sysdepends_TSQL sys.sysdepends
dev_langs	TSQL
helpviewer_keywords	sysdepends system table sys.sysdepends compatibility view
ms.assetid	f9c182cb-386f-4e72-859f-9f1115b389f9
author	rothja
ms.author	jroth

sys.sysdepends (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

Contains dependency information between objects (views, procedures, and triggers) in the database, and the objects (tables, views, and procedures) that are contained in their definition.

Important

[!INCLUDEssnoteCompView]

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	[!INCLUDEssInternalOnly]
deptype	tinyint	Identifies the dependent object type: 0 = Object or column (non-schema-bound references only 1 = Object or column (schema-bound references)
depdbid	smallint	[!INCLUDEssInternalOnly]
depsiteid	smallint	[!INCLUDEssInternalOnly]
selall	bit	1 = Object is used in a SELECT * statement. 0 = No.
resultobj	bit	1 = Object is being updated. 0 = No.
readobj	bit	1 = The object is being read. 0 = No.

See Also

Mapping System Tables to System Views (Transact-SQL)
Compatibility Views (Transact-SQL)
sp_depends (Transact-SQL)
sys.sql_dependencies (Transact-SQL)