看不到我在 SQL Server Management Studio 2008 中创建的触发器 [英] Can't see the triggers that I created in SQL Server Management Studio 2008

问题描述

我在相册表上创建了一个简单的触发器.但是该触发器在触发器文件夹中的可编程性的对象资源管理器中不可见.我刷新了该文件夹并重新启动了 SSMS，但仍然没有运气.但是我可以在触发器文件夹中的该表下看到该触发器.这是功能还是错误?

I created a simple trigger on Albums table. But that trigger is not visible in object explorer in programmability in triggers folder. I refreshed that folder as well as restarted the SSMS but still no luck. However i can see that trigger under that table in triggers folder. Is this a feature or a bug?

我使用的是 SQL Server 2008.

I am using SQL Server 2008.

推荐答案

Programmability 中的触发器用于数据库触发器 (DDL 触发器).如果您展开表，您可以查看表触发器(DML 触发器).例如，您正在寻找表students"的触发器如下:展开表格"=> 展开学生"=> 在这里您将在触发器节点中找到 DML 触发器.

The triggers in Programmability is for database triggers (DDL Triggers). You can view the table triggers (DML Triggers) if you expand the table. For example, you are looking for triggers for table "students" Follow: expand "Tables"=> Expand "students"=> Here you will find DML triggers in Triggers Node.

这篇关于看不到我在 SQL Server Management Studio 2008 中创建的触发器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！