drop table on cascade constraints code example Example: oracle sql drop table DROP TABLE my_table; -- To 'really' free space DROP TABLE my_table PURGE;