如何使用 SQL Server 查找与表关联的所有触发器? [英] How to find all trigger associated with a table with SQL Server?

问题描述

我在 SQL Server 中为一个表创建了一个触发器，它对我有用.

I created a trigger for a table in SQL Server and it works for me.

我的问题是:如何找到并修改它?

My problem is: How do find it and modify it?

我使用此查询来查找触发器:

I use this query to find my triggers:

select * from sys.triggers

这个可以找到所有的触发器，但是如何打开它并更改触发器?

This find all triggers, but how to open it and change the triggers?

推荐答案

您只需使用 SSMS 即可完成此操作.只需转到您的表名并展开触发器节点即可查看与该表关联的触发器列表.右键单击以修改触发器.

You can do this simply with SSMS. Just go to your table name and expand the Triggers node to view a list of triggers associated with that table. Right click to modify your trigger.

这篇关于如何使用 SQL Server 查找与表关联的所有触发器?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！