SQL Server Syntax Trigger on an INSERT, UPDATE, or DELETE statement to a table or view (DML Trigger) DROP TRIGGER [schema_name.]trigger_name [ ,...n ] ...
msdn.microsoft.com