Oracle PL/SQL Tutorial/Trigger/IS DROP COLUMN
IS_DROP_COLUMN
<source lang="sql">
SQL> CREATE OR REPLACE TRIGGER what_got_dropped
2 AFTER ALTER ON SCHEMA 3 BEGIN 4 IF IS_DROP_COLUMN("COL2") THEN 5 DBMS_OUTPUT.PUT_LINE("You dropped col2"); 6 END IF; 7 END; 8 /
Trigger created. SQL> SQL> drop trigger what_got_dropped; Trigger dropped.</source>