DROP TRIGGER |
DROP TRIGGER [schema.]trigger_name |
Removes a trigger from the database.
Keywords
schema
The name of the schema containing the trigger to be dropped. If omitted, the current schema is assumed.
triggername
Specifies the name of the trigger to be dropped.
Example
The following statement removes the empaud trigger from the database:
DROP TRIGGER empaud
Get Oracle SQL: the Essential Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.