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.
2016-10-24, 631👍, 0💬
Popular Posts:
How To Install PHP on Windows in MySQL? The best way to download and install PHP on Windows systems ...
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...
How to run Queries with "sqlcmd" tool in SQL Server? "sqlcmd" is a client tool that you can use to i...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...