SQL Server - sys.triggers - Listing All Triggers in the Database in SQL Server

sys.triggers - Listing All Triggers in the Database in SQL Server

Q

How To List All Triggers in the Database with sys.triggers in SQL Server?

✍: FYIcenter.com

A

If you want to list all triggers defined in the current database, you can use the catalog view, sys.triggers, as shown in the following tutorial example:

USE FyiCenterData;
GO

CREATE TRIGGER new_user ON fyi_users
AFTER INSERT 
AS
  PRINT 'New users added.';
GO

SELECT * FROM sys.triggers
GO
name         object_id   parent_id   type type_desc   
------------ ----------- ----------- ---- ------------
dml_message  690101499   674101442   TR   SQL_TRIGGER 
new_user     706101556   674101442   TR   SQL_TRIGGER

The result shows that there are 2 triggers defined in FyiCenterData.

⇒Creating and Managing Triggers in SQL Server

⇒⇒SQL Server Database Tutorials

2016-10-25, 740👍, 0💬

Testing DML Triggers in SQL Server
How To Test a DML Trigger in SQL Server? To test a DML trigger defined on a table, you just need to execute several INSERT, UPDATE and DELETE statements on that table as shown in this tutorial example: USE FyiCenterData; GO INSERT INTO fyi_users (name) VALUES ('FYI Admin'); GO Records are inserted, ... 2016-10-25, 577👍, 0💬

"CREATE TRIGGER" - Creating a DML Trigger in SQL Server
How To Create a DML Trigger using CREATE TRIGGER Statements in SQL Server? A DML trigger is a trigger declared to handle a DML event, which occurs when an INSERT, UPDATE or DELETE statement is executed. If you want to create a DML trigger, you should use the "CREATE TRIGGER" statement in the followi... 2016-10-25, 574👍, 0💬

"ALTER TRIGGER" - Modifying Existing Triggers in SQL Server
How To Modify Existing Triggers using "ALTER TRIGGER" in SQL Server? If you want to make changes to an existing trigger, you could use the "ALTER TRIGGER" statements to refine the trigger again. The tutorial exercise below shows you how to modify the trigger defined in a previous tutorial: USE FyiCe... 2016-10-24, 527👍, 0💬

"DROP TRIGGER" - Deleting Existing Triggers in SQL Server
How To Delete Existing Triggers using "DROP TRIGGER" in SQL Server? If you don't want to use a trigger any more, you should delete it from the database by using the "DROP TRIGGER" statement as shown in tutorial example: USE FyiCenterData; GO DROP TRIGGER new_user; GO SELECT * FROM sys.triggers GO na... 2016-10-24, 526👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.