天天看點

查詢資料庫所有觸發器

Oracle:

select trigger_name from all_triggers where table_name='XXX';      
sqlserver:      
select name from sysobjects where xtype='TR';
      
mysql:      
show TRIGGERS;