Home

	Expand Search

Transact-SQL User's Guide

Chapter 16 Triggers: Enforcing Referential Integrity

Getting information about triggers

sp_depends

sp_depends

sp_depends lists the triggers that reference an object or all the tables or views that the trigger affects. This example shows how to use sp_depends to get a list of all the objects referenced by the trigger deltitle:

sp_depends deltitle 

Things the object references in the current database. 

object              type       updated  selected 
----------------    ----------  ------- -------- 
dbo.salesdetail     user table  no      no
dbo.titles          user table  no      no
 
(return status = 0)

This statement lists all the objects that reference the salesdetail table:

sp_depends salesdetail 

Things inside the current database that reference the object.
 
object                       type         
---------------------------  ----------------  
dbo.deltitle                 trigger         
dbo.history_proc             stored procedure  
dbo.insert_salesdetail_proc  stored procedure
dbo.totalsales_trig          trigger 
 
(return status = 0)