[mssql] 제약조건 활성화/비활성화

비활성화

ALTER TABLE [테이블명] NOCHECK constraint [제약조건명]

 

EX) ALTER TABLE TB_TRAN_DT NOCHECK constraint FK_TB_TRAN_DT_HD

활성화

ALTER TABLE [테이블명] CHECK constraint [제약조건명]

 

EX) ALTER TABLE TB_TRAN_DT CHECK constraint FK_TB_TRAN_DT_HD