SQL> drop table emp purge; drop table emp purge * ERROR at line 1: ORA-02449: unique/primary keys in table referenced by foreign keys SQL> drop table emp cascade constraints; Table dropped.