반응형
- /**********************************************************************************************
-- Title : [2k] 테이블 DEFAULT 설정(WITH VALUES)
-- Reference : dBRang.com
-- Key word : alter table, default, with values
**********************************************************************************************/
-- WITH VALUES 옵션 설정시
CREATE TABLE ttt
(a INT, b CHAR(2))
ALTER TABLE ttt
ADD CONSTRAINT df_ttt DEFAULT 333 FOR a
INSERT INTO ttt (b) VALUES ('kk')
SELECT * FROM ttt
ALTER TABLE ttt
ADD adddate SMALLDATETIME NULL
CONSTRAINT adddatedflt
DEFAULT getdate() WITH VALUES
SELECT * FROM ttt
/*
a b adddate
----------- ---- -------------------
333 kk 2005-09-14 16:46:00
(1개 행 적용됨)
*/
-- WITH VALUES 옵션 제거시
CREATE TABLE ttt2
(a INT, b CHAR(2))
ALTER TABLE ttt2
ADD CONSTRAINT df_ttt2 DEFAULT 333 FOR a
INSERT INTO ttt2 (b) VALUES ('kk')
SELECT * FROM ttt2
ALTER TABLE ttt2
ADD adddate SMALLDATETIME NULL
CONSTRAINT adddatedflt2
DEFAULT getdate() --WITH VALUES
SELECT * FROM ttt2
/*
a b adddate
----------- ---- -------------------
333 kk NULL
*/
반응형