sqlserver查找某個(gè)表的觸發(fā)器triggers
發(fā)布時(shí)間：2024/6/19 9:08:54 作者：Admin 閱讀：77
廣告：
SELECT name AS '觸發(fā)器名稱', OBJECT_NAME(parent_id) AS '關(guān)聯(lián)表', type_desc AS '觸發(fā)器類型', OBJECT_DEFINITION(object_id) AS '觸發(fā)器定義'
FROM sys.triggers
WHERE parent_class = 1 AND OBJECT_NAME(parent_id) = 'YourTableName';
如：
SELECT name AS tname, OBJECT_NAME(parent_id) AS ttable, type_desc AS ttype, OBJECT_DEFINITION(object_id) AS tdefine
FROM sys.triggers
WHERE parent_class = 1 AND OBJECT_NAME(parent_id) = 'a_user';
廣告：
相關(guān)文章
