"DROP TRIGGER" - Deleting Existing Triggers in SQL Server


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

✍: FYIcenter.com


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;

DROP TRIGGER new_user;

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

Trigger, new_user, is deleted now.


sys.sql_modules - Getting Trigger Definitions Back in SQL Server

"ALTER TRIGGER" - Modifying Existing Triggers in SQL Server

Creating and Managing Triggers in SQL Server

⇑⇑ SQL Server Database Tutorials

2016-10-24, 1210🔥, 0💬