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, 1229🔥, 0💬
Popular Posts:
How To Set Up SQL*Plus Output Format in Oracle? If you want to practice SQL statements with SQL*Plus...
Where to find answers to frequently asked questions I am new to Oracle database. Here is a list of f...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and...