mysql库表的触发器表名_如何在数据库中查询出所有有触发器的表，求代码和说明？...

展开全部

Oracle  数据库的话62616964757a686964616fe4b893e5b19e31333332633038：SQL> SELECT

2    trigger_name,

3    status

4  FROM

5    user_triggers

6  WHERE

7    table_name='TEST_TRIGGER_TABLE';

TRIGGER_NAME                                                 STATUS

------------------------------------------------------------ ----------------

BEFOREALLTEST                                                ENABLED

BEFOREALLTEST2                                               ENABLED

SQL Server 的话select

tri.name  AS  TriggerName,

tri.is_disabled AS IsDisable,

tri.is_instead_of_trigger AS IsInsteadOfTrigger,

c.text AS CreateTriggerSQL

from

sys.triggers tri LEFT OUTER JOIN

dbo.syscomments c ON tri.object_id = c.id