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

컬럼 추가

ALTER TABLE ${TALBE_NAME} ADD ${COLUMN_NAME} ${COLUMN_TYPE}                                                        

EX) BOARD 테이블에 컬럼명이 DEL_YN인 컬럼을 추가

ALTER TABLE BOARD ADD DEL_YN CHAR(1) NOT NULL DEFAULT 'N'                                                                  

컬럼 수정

ALTER TABLE ${TABLE_NAME} ALTER COLUMN ${COLUMN_NAME} ${COLUMN_TYPE}                                        

EX) BOARD 테이블에 컬럼명이 BOARD_SUBJECT인 컬럼을 수정

ALTER TABLE BOARD ALTER COLUMN BOARD_SUBJECT VARCHAR(200)                                                             

컬럼 삭제

ALTER TABLE ${TABLE_NAME} DROP COLUMN ${COLUMN_NAME}                                                                    

EX) BOARD 테이블에 컬럼명이 DEL_YN인 컬럼을 삭제

ALTER TABLE BOARD DROP COLUMN DEL_YN