天天看点

查询数据库所有触发器

Oracle:

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