展开全部
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
最后
以上就是高高心情最近收集整理的关于mysql库表的触发器表名_如何在数据库中查询出所有有触发器的表,求代码和说明?...的全部内容,更多相关mysql库表内容请搜索靠谱客的其他文章。
发表评论 取消回复