Dropping Triggers

You must drop a trigger before dropping the objects on which it depends.

To drop a trigger, use either the SQL Developer navigation frame and Drop tool, or the DDL statement DROP TRIGGER.

To drop a trigger using the Drop tool:

1. On the Connections tab, expand hr_conn.

   Under the hr_conn icon, a list of schema object types appears.

2. Expand Triggers.

   A list of triggers appears.

3. Right-click the name of the trigger to drop.

   A list of choices appears.

4. Click Drop Trigger.

   The Drop window opens.

5. Click Apply.

   The Confirmation window opens.

6. Click OK.