DB/oracle
테이블-컬럼 수정/추가/삭제
datajoy
2019. 10. 10. 23:38
1.컬럼추가
ALTER TABLE (table_name) ADD (column) (datatype);
commit;
2.컬럼수정
ALTER TABLE (table_name) MODIFY (column) (datatype);
commit;
3.컬럼삭제
ALTER TABLE (table_name) DROP COLUMN (column);
commit;
4.컬럼명 변경
ALTER TABLE (table_name) RENAME COLUMN (원래컬럼명) TO (변경컬럼명);
commit;