Drop trigger in Oracle




Syntax

To drop a trigger in Oracle, use the DROP TRIGGER statement. Here is the generic syntax:

DROP TRIGGER [IF EXISTS] [schema_name].trigger_name;

You might specify the schema containing the trigger, but you can also omit it. Oracle will then assume that the trigger is in the current schema:

DROP TRIGGER [IF EXISTS] trigger_name;

Example

To drop the trigger age_check:

DROP TRIGGER age_check;

TO double check the status of the DROP TRIGGER statement:

SELECT TRIGGER_NAME, STATUS FROM USER_TRIGGERS where upper(TRIGGER_NAME) = 'age_check';

If done right, the result will then be:

no rows selected.

---

Need a good GUI tool for databases? TablePlus provides a native client that allows you to access and manage Oracle, MySQL, SQL Server, PostgreSQL and many other databases simultaneously using an intuitive and powerful graphical interface.

Download TablePlus for Mac.

Not on Mac? Download TablePlus for Windows.

Need a quick edit on the go? Download for iOS