MSSQL DEFAULT값 SETTING

MSSQL DEFAULT값 넣기 ..MSSQL 디폴트값 집어 넣기 ..

 

ALTER TABLE [TABLE_NAME] ADD CONSTRAINT [CONSTRAINT_NAME] default 0 for COLUMN_NAME

 

다중 디폴트값 넣기 가능 .

ALTER TABLE [TABLE_NAME] ADD CONSTRAINT [CONSTRAINT_NAME]  DEFAULT 0   FOR     COLUMN_NAME

                                                    ,CONSTRAINT [CONSTRAINT_NAME] DEFAULT 0    FOR COLUMN_NAME