Name
DROP TRIGGER
Synopsis
The DROP TRIGGER
command removes a
trigger for a table within the current database.
|
Vendor |
Command |
|---|---|
|
SQL Server |
Supported, with variations |
|
MySQL |
Not supported |
|
Oracle |
Supported, with variations |
|
PostgreSQL |
Supported, with variations |
SQL99 Syntax and Description
DROP TRIGGER trigger_name
DROP TRIGGER removes a trigger from the current
database. MySQL does not support this command.
Microsoft SQL Server Syntax and Variations
DROP TRIGGER [owner_name.]trigger_name [,...n] GO
Microsoft SQL Server allows multiple triggers to be dropped by placing a comma between each trigger name.
Oracle Syntax and Variations
DROP TRIGGER [owner_name.]trigger_name;
Oracle drops the indicated trigger and commits pending changes to the database when this command is executed.
PostgreSQL Syntax and Variations
DROP TRIGGER trigger_name ON table_name;
PostgreSQL requires that the table where the trigger resides is named. It then drops all references to an existing trigger when this command is executed.