{"id":176,"date":"2015-12-09T11:01:57","date_gmt":"2015-12-09T02:01:57","guid":{"rendered":"http:\/\/www.onepage.co.kr\/wordpress\/?p=176"},"modified":"2015-12-09T11:02:36","modified_gmt":"2015-12-09T02:02:36","slug":"table-column-property-change-column-constraints","status":"publish","type":"post","link":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/2015\/12\/09\/table-column-property-change-column-constraints\/","title":{"rendered":"Table Column Property Change & column constraints"},"content":{"rendered":"

\u200b<\/a><\/p>\n

Table Column\uc758 \uc18d\uc131\uc744 \ubcc0\uacbd\ud558\uac70\ub098 \uc0ad\uc81c\ud558\uace0\uc790 \ud560 \uacbd\uc6b0 column \uc81c\uc57d \uc870\uac74\uc73c\ub85c \uc18d\uc131 \ubcc0\uacbd\uc774 \ubd88\uac00\ub2a5\ud55c \uacbd\uc6b0\uac00 \uc885\uc885 \ubc1c\uc0dd\u00a0<\/span><\/div>\n
\ud55c\ub2e4.<\/div>\n
<\/div>\n
\ud504\ub85c\uc81d\ud2b8 \uac1c\ubc1c\uc911\uc5d4 Column \uc18d\uc131\uc744 \ubcc0\uacbd\ud560 \uc77c\uc774 \uc885\uc885 \ubc1c\uc0dd\ud558\ubbc0\ub85c \uad00\ub828 \uc0ac\ud56d\uc744 \uc815\ub9ac\ud574 \ub454\ub2e4.<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
Table\uc758 \ud2b9\uc815 column \uc18d\uc131 \uc218\uc815\uc2dc Result<\/div>\n
<\/div>\n
Msg 5074, Level 16, State 1, Line<\/div>\n
2<\/div>\n
\uac1c\uccb4 ‘DF__A1_Studen__schoo__7A521F79’\uc740(\ub294)<\/div>\n
\uc5f4 ‘school3’\uc5d0 \uc885\uc18d\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4.<\/div>\n
Msg 4922, Level<\/div>\n
16, State 9, Line 2<\/div>\n
\ud558\ub098 \uc774\uc0c1\uc758 \uac1c\uccb4\uac00 \uc774 \uc5f4\uc5d0\u00a0<\/span><\/div>\n
\uc561\uc138\uc2a4\ud558\ubbc0\ub85c ALTER TABLE ALTER COLUMN school3\uc774(\uac00) \uc2e4\ud328\ud588\uc2b5\ub2c8\ub2e4.<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
\ubb38\uc81c\uac00 \ub41c\u00a0Column\uc744 \uc0dd\uc131\ud560 \ub54c not null \uc18d\uc131\uacfc default \uac12\uc744 \uc801\uc6a9\ud55c \uc0c1\ud0dc\uc600\ub2e4. \ub2e4\uc74c \ubb38\uc81c\uc758 \ud574\uacb0\ucc45\uc740 column\uc5d0<\/div>\n
<\/div>\n
\ubd80\uc5ec\ub41c \ubaa8\ub4e0 \uc81c\uc57d \uc870\uac74\uc744 \uc0ad\uc81c \ud6c4 \uc6d0\ub798\uc758 \uc791\uc5c5\uc744 \uc9c4\ud589\ud558\ub294 \uac83\uc774\ub2e4.<\/div>\n
<\/div>\n
msdn\uc744 \ucc38\uace0\ud558\uba74 \uc81c\uc57d \uc870\uac74 \uc0ad\uc81c\ub97c \uc704\ud574 \uc544\ub798 query\ub97c \uc81c\uc2dc \ud558\uace0 \uc788\ub2e4.<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
alter table <PublishedTableName><\/div>\n
<\/div>\n
drop constraint<\/div>\n
<ConstraintName><\/div>\n
go<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
PublishedTableName\uc740 \ud574\ub2f9 Table\uba85\uc774 \ub420\uac83\uc774\uace0 ConstraintName\uc740 \uc624\ub958 \ubc1c\uc0dd\uc2dc ‘\uac1c\uccb4’ \uba85\uc774\ub2e4. SSMS<\/div>\n
Results \ucc3d\uc5d0 \ud45c\uc2dc\ub41c<\/div>\n
<\/div>\n
\uac1c\uccb4\uba85\u00a0‘DF__A1_Studen__schoo__7A521F79’ \ub97c \uc801\uc6a9\ud558\uc5ec \ubc1c\uc0dd\ud55c<\/div>\n
\ubb38\uc81c\ub97c \ud574\uacb0\ud560 \uc218 \uc788\uc5c8\ub2e4.<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
\ucc38\uace0: http:\/\/support.microsoft.com\/kb\/816755\/ko<\/div>\n","protected":false},"excerpt":{"rendered":"

\u200b Table Column\uc758 \uc18d\uc131\uc744 \ubcc0\uacbd\ud558\uac70\ub098 \uc0ad\uc81c\ud558\uace0\uc790 \ud560 \uacbd\uc6b0 column \uc81c\uc57d \uc870\uac74\uc73c\ub85c \uc18d\uc131 \ubcc0\uacbd\uc774 \ubd88\uac00\ub2a5\ud55c \uacbd\uc6b0\uac00 \uc885\uc885 \ubc1c\uc0dd\u00a0 \ud55c\ub2e4. \ud504\ub85c\uc81d\ud2b8 \uac1c\ubc1c\uc911\uc5d4 Column \uc18d\uc131\uc744 \ubcc0\uacbd\ud560 \uc77c\uc774 \uc885\uc885 \ubc1c\uc0dd\ud558\ubbc0\ub85c \uad00\ub828 \uc0ac\ud56d\uc744 \uc815\ub9ac\ud574 \ub454\ub2e4. Table\uc758 \ud2b9\uc815 column \uc18d\uc131 \uc218\uc815\uc2dc Result Msg 5074, Level 16, State 1, Line 2 \uac1c\uccb4 ‘DF__A1_Studen__schoo__7A521F79’\uc740(\ub294) \uc5f4 ‘school3’\uc5d0 \uc885\uc18d\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. Msg 4922, Level 16, State […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-176","post","type-post","status-publish","format-standard","hentry","category-mssql"],"_links":{"self":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/176","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/comments?post=176"}],"version-history":[{"count":1,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/176\/revisions"}],"predecessor-version":[{"id":177,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/176\/revisions\/177"}],"wp:attachment":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/media?parent=176"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/categories?post=176"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/tags?post=176"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}