DROP TRIGGER SQL Server

SQL Server > DDL > DROP TRIGGER          

Removes one or more triggers from the current database.

• 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.

Example:

drop trigger trg_asset_after_update