List triggers in Db2 database

Query below lists triggers in a database with their details.


    trigname as trigger_name,
    tabschema concat '.' concat tabname as table_name, 
    case trigtime 
         when 'B' then 'before'
         when 'A' then 'after'
         when 'I' then 'instead of' 
    end as activation,
    rtrim(case when eventupdate ='Y' then  'update ' else '' end 
          case when eventdelete ='Y' then  'delete ' else '' end
          case when eventinsert ='Y' then  'insert ' else '' end)
    as event,   
    case when ENABLED = 'N' then 'disabled'
    else 'active' end as status,
    text as definition
from syscat.triggers t
where tabschema not like 'SYS%'
order by trigname


  • trigger_name - name of the trigger
  • table_name - name of the trigger table (for table triggers) with schema name
  • activation - trigger activation time: before, after or instead of
  • event - specific SQL operation: insert, update or delete, multiple events
  • status - trigger status
    • Active
    • Disabled
  • definition - SQL definiton of trigger


  • One row represents one trigger
  • Scope of rows: all found triggers in a database
  • Ordered by schema name, table name, trigger name

Sample results

Comments are only visible when the visitor has consented to statistics cookies. To see and add comments please accept statistics cookies.
There are no comments. Click here to write the first comment.