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

Triggers - List All - SQL Server

RSS
Modified on Mon, Aug 01, 2011, 5:18 PM by Administrator Categorized as 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

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