Drop Trigger Syntax

DROP TRIGGER trigger_name;

Drop Trigger Example

CREATE TRIGGER Customers_Op
      ON Customers
 AFTER UPDATE
AS
   UPDATE Customers
         SET address = UPPER('ADDRESS_5')
    WHERE customer_id = 5
GO

DROP TRIGGER Customers_Op;

See also:
SQL Server