이하늘의 Dev Note

BEGIN
  FOR cur_rec IN (SELECT object_name, object_type FROM user_objects WHERE object_type IN ('TABLE', 'VIEW'))
  LOOP
    BEGIN
      IF cur_rec.object_type = 'TABLE' THEN
        EXECUTE IMMEDIATE 'DROP ' || cur_rec.object_type || ' "' || cur_rec.object_name || '" CASCADE CONSTRAINTS';
      ELSE
        EXECUTE IMMEDIATE 'DROP ' || cur_rec.object_type || ' "' || cur_rec.object_name || '"';
      END IF;
    EXCEPTION
      WHEN OTHERS THEN
        DBMS_OUTPUT.put_line('Unable to drop ' || cur_rec.object_type || ' "' || cur_rec.object_name || '": ' || SQLERRM);
    END;
  END LOOP;
END;
/

오라클에서 테이블을 전체삭제하는 쿼리이다. 

테이블의 관계성, 의존성등 모두 삭제하므로 주의해야한다.