How to delete trigger in SQL Server?

I can Drop a Trigger with the Following Query

DROP TRIGGER [Trigger_Name]

          (OR)            

DROP TRIGGER Trigger_Update

Hope this Must helpfull...


DROP TRIGGER:

Removes one or more triggers from the current database...

You can remove a trigger by dropping it or by dropping the trigger table. When a table is dropped, all associated triggers are also dropped. When a trigger is dropped, information about the trigger is removed from the sysobjects and syscomments system tables.

Use DROP TRIGGER and CREATE TRIGGER to rename a trigger. Use ALTER TRIGGER to change the definition of a trigger...


For SQL Server 2016 and above

DROP TRIGGER IF EXISTS [dbo].[trg] ON [dbo].[Table]

https://docs.microsoft.com/en-us/sql/t-sql/statements/drop-trigger-transact-sql


To drop a trigger, this works:

DROP TRIGGER [trigger_name];  

If you want to check weather trigger exist before a drop, then use:

SELECT * FROM [sys].[triggers] WHERE [name] = 'MyTrigger'

For more check out http://www.tsql.info/triggers/drop-trigger.php and https://stackoverflow.com/a/636470/2218697