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, 1303🔥, 0💬
Popular Posts:
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measu...
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...