September 2000
Intermediate to advanced
418 pages
11h 5m
English
Content preview from Oracle SQL: the Essential Reference
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
| 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