[ORACLE] 컬럼 추가, 수정, 삭제

출처: http://munduki.tomeii.com/darkhorse/entry/ORACLE-%C4%C3%B7%B3-%C3%DF%B0%A1-%BC%F6%C1%A4-%BB%E8%C1%A6

ALTER TABLE 구테이블명 RENAME TO 신테이블명;
ALTER TABLE [TABLE NAME] RENAME COLUMN [COLUMN NAME] TO [NEW COLUMN NAME];

--컬럼명 바꾸기

ALTER TABLE high_tax RENAME COLUMN year_comm TO tax ;

--컬럼수정

alter table  high_tax modify ( tax number(10,2)  ) ;

--컬럼 삭제

Alter table  high_tax Drop ( tax );

--컬럼추가

Alter table  high_tax add ( tax number(10,2)  default 2000  );