본문 바로가기

DataBase/ORACLE

Oracle 테이블 일괄 삭제

Begin

for c in (select table_name from user_tables) loop

execute immediate ('drop table '||c.table_name||' cascade constraints');

end loop;

End;


출처 : http://egloos.zum.com/repository/v/5784539