DROP TRIGGER

Remove one or more triggers from the current database.

Syntax
   DML Trigger: (INSERT, UPDATE, DELETE)
     DROP TRIGGER [schema.]trigger [,...n ] [ ; ]

   DDL Trigger: (CREATE, ALTER, DROP, GRANT, DENY, REVOKE, UPDATE)
     DROP TRIGGER trigger [,...n ] ON DATABASE [; ]
     DROP TRIGGER trigger [,...n ] ON ALL SERVER [; ]

Key
   trigger    Name of the trigger to remove
   DATABASE   Apply to the current database
   ALL SERVER Apply to the current server

When a table is dropped, all associated triggers are automatically dropped.

Examples

DROP TRIGGER MyTrigger

"A business that makes nothing but money is a poor kind of business" - Henry Ford

Related commands:

CREATE TRIGGER
ALTER TRIGGER
DISABLE TRIGGER
sys.triggers
Equivalent Oracle command: DROP TRIGGER