[MS-SQL] ALTER 테이블 컬럼 조작

*

컬럼 추가 : ALTER TABLE ~ ADD ~

ALTER TABLE (table_name) ADD (column_name) (column_type)
ex) ALTER TABLE Users ADD user_name varchar(10) not null

*

컬럼수정 : ALTER TABLE ~ ALTER COLUMN ~

ALTER TABLE (table_name) ALTER COLUMN (column_name) (column_type)
ex) ALTER TABLE Users ALTER COLUMN user_name varchar(20) null

컬럼명 수정 : EXEC SP_RENAME ~

EXEC SP_RENAME ('table_name.[old_column_name]'), ('new_column_name'), ('column')
ex) EXEC SP_RENAME 'Users.[user_name]', 'user_nm', 'column'

*

컬럼 삭제 : ALTER TABLE ~ DROP COLUMN ~

ALTER TABLE (table_name) DROP COLUMN (column_name)
ex) ALTER TABLE Users DROP COLUMN user_name

[출처] [MS-SQL] ALTER 테이블 컬럼 조작|작성자 dmswn11kr