Navigation

	Home Page
	Index
	All Pages

Contributor Links

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

Other Wiki Sections

Software

Triggers - List All - SQL Server

select 
     SchemaName     = s.name
    ,TableName      = tbl.name
    ,TriggerName    = tr.name 
    
from 
    sys.objects tr

    inner join sys.objects tbl
        on tr.parent_object_id = tbl.object_id

    inner join sys.schemas s
        on tbl.schema_id = s.schema_id

where 1=1
    and tr.type = 'TR'
    and tbl.type = 'U'

order by 
     SchemaName
    ,TableName
    ,TriggerName