Oracle SQL 제약조건 삭제방법

alter table member drop column id cascade constraints
그리고 이어서
drop table member

• MEMBER

  alter table member drop column id cascade constraints;
  drop table member;

• BBS

  alter table bbs drop column no cascade constraints;
  drop table bbs;

• BBS_COMMENT

  drop table bbs_comment;

• 휴지통 비우기
  purge recyclebin;