List triggers by table name in Db2 database

Article for: Teradata MySQL MariaDB

Query below lists tables with their triggers.


    tabschema concat '.' concat tabname as table_name, 
    trigname as trigger_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 table_name, trigger_name


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


  • One row represents one trigger
  • Scope of rows: all column, table triggers in a database
  • Ordered by schema and 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.