반응형
1. 컬럼 추가
ALTER TABLE tablename) ADD columnname columntype
EX) null 허용
ALERT TABLE Tbl_test ADD columnname NVARCHAR(10) NULL;
EX) null 허용안함
ALERT TABLE Tbl_test ADD columnname NVARCHAR(10) NOT NULL CONSTRAINT DF_ADDR DEFAULT 'N';
2. 컬럼 수정
ALTER TABLE tablename ALTER COLUMN columnname columntype
EX)
ALTER TABLE Tbl_test ALTER COLUMN SECURITY VARCHAR(1) NULL;
3. 컬럼명 수정
EXEC SP_RENAME 'Tbl_test.old_columnname', 'new_columnname', 'COLUMN'
EX)
EXEC SP_RENAME 'Tbl_test.old_column', 'new_column', 'COLUMN';
4. 컬럼 삭제
ALTER TABLE tablename DROP COLUMN columnname
EX)
ALTER TABLE Tbl_test DROP COLUMN columnname;
참고.
https://msdn.microsoft.com/ko-kr/library/ms190273(v=sql.120).aspx
반응형