"DROP TRIGGER" - Deleting Existing Triggers in SQL Server

Q

How To Delete Existing Triggers using "DROP TRIGGER" in SQL Server?

✍: FYIcenter.com

A

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
name         object_id   parent_id   type type_desc   
------------ ----------- ----------- ---- ------------
dml_message  690101499   674101442   TR   SQL_TRIGGER 

Trigger, new_user, is deleted now.

 

Creating and Managing Triggers in SQL Server

⇒⇒SQL Server Database Tutorials

2016-10-24, 525👍, 0💬