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, 1642🔥, 0💬
Popular Posts:
How To Convert Binary Strings into Integers in SQL Server Transact-SQL? Binary strings and integers ...
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
How To Generate CREATE TABLE Script on an Existing Table in SQL Server? If you want to know how an e...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...