Collections:
"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; 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.
⇒ sys.sql_modules - Getting Trigger Definitions Back in SQL Server
⇐ "ALTER TRIGGER" - Modifying Existing Triggers in SQL Server
2016-10-24, 1241🔥, 0💬
Popular Posts:
How To Generate CREATE TABLE Script on an Existing Table in SQL Server? If you want to know how an e...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...