{"id":3534,"date":"2016-02-29T23:27:17","date_gmt":"2016-02-29T23:27:17","guid":{"rendered":"http:\/\/www.gencayyildiz.com\/blog\/?p=3534"},"modified":"2016-02-29T23:27:17","modified_gmt":"2016-02-29T23:27:17","slug":"t-sqlde-alter-komutu","status":"publish","type":"post","link":"https:\/\/www.gencayyildiz.com\/blog\/t-sqlde-alter-komutu\/","title":{"rendered":"T-SQL&#8217;de Alter Komutu"},"content":{"rendered":"<div id=\"fb-root\"><\/div>\n<p>\u00d6nceki yaz\u0131lar\u0131mdan <a href=\"http:\/\/www.gencayyildiz.com\/blog\/transact-sql-ddldata-definition-language\/\" target=\"_blank\">Transact Sql-DDL(Data Definition Language)<\/a> ba\u015fl\u0131kl\u0131 yaz\u0131mda Alter komutundan bahsetmi\u015ftim. Lakin ilgili yaz\u0131da alter komutu \u00fczerine fazla durmam\u0131\u015f, bir ka\u00e7 i\u015flemi es ge\u00e7mi\u015ftim. \u015eimdi o eksi\u011fi kapatal\u0131m&#8230;<\/p>\n<p>\u00d6ncelikle T-SQL ile bir tablonun ad\u0131n\u0131n nas\u0131l de\u011fi\u015ftirece\u011fine de\u011finelim.<\/p>\n<pre class=\"brush: jscript; title: ; notranslate\" title=\"\">\r\nSP_RENAME 'OrnekTablo','OrnekTabloYeni'\r\n<\/pre>\n<p>Olan bir tabloya kolon ekleyelim ve var olan kolonun ad\u0131n\u0131 g\u00fcncelleyelim.<br \/>\nEkleme.<\/p>\n<pre class=\"brush: jscript; title: ; notranslate\" title=\"\">\r\nAlter table OrnekTablo\r\nAdd OrnekKolon3 nvarchar(MAX)\r\n<\/pre>\n<p>G\u00fcncelleme.<\/p>\n<pre class=\"brush: jscript; title: ; notranslate\" title=\"\">\r\nSP_RENAME 'OrnekTablo.OrnekKolon3', 'OrnekKolon4', 'Column'\r\n<\/pre>\n<p>\u015eimdide kolonun tipini g\u00fcncelleyelim.<\/p>\n<pre class=\"brush: jscript; title: ; notranslate\" title=\"\">\r\nAlter Table OrnekTablo\r\nAlter Column OrnekKolon3 int\r\n<\/pre>\n<p>Var olan kolonu silelim.<\/p>\n<pre class=\"brush: jscript; title: ; notranslate\" title=\"\">\r\nAlter Table OrnekTablo\r\nDrop Column OrnekKolon3\r\n<\/pre>\n<p>\u015eimdide Constraint ekleyerek, silelim.<br \/>\nEkleme.<\/p>\n<pre class=\"brush: jscript; title: ; notranslate\" title=\"\">\r\nAlter Table OrnekTablo\r\nAdd Constraint OrnekConstraint Default 'Bo\u015f' for OrnekKolon1\r\n<\/pre>\n<p>Silme.<\/p>\n<pre class=\"brush: jscript; title: ; notranslate\" title=\"\">\r\nAlter Table OrnekTablo\r\nDrop Constraint OrnekConstraint\r\n<\/pre>\n<p>Hepinize iyi \u00e7al\u0131\u015fmalar dilerim&#8230;<\/p>\n<!-- AddThis Advanced Settings generic via filter on the_content --><!-- AddThis Share Buttons generic via filter on the_content -->","protected":false},"excerpt":{"rendered":"<p>\u00d6nceki yaz\u0131lar\u0131mdan Transact Sql-DDL(Data Definition Language) ba\u015fl\u0131kl\u0131 yaz\u0131mda Alter komutundan bahsetmi\u015ftim. Lakin ilgili yaz\u0131da alter komutu \u00fczerine fazla durmam\u0131\u015f, bir ka\u00e7 i\u015flemi es ge\u00e7mi\u015ftim. \u015eimdi o eksi\u011fi kapatal\u0131m&#8230; \u00d6ncelikle T-SQL ile bir tablonun ad\u0131n\u0131n&#46;&#46;&#46;<!-- AddThis Advanced Settings generic via filter on get_the_excerpt --><!-- AddThis Share Buttons generic via filter on get_the_excerpt --><\/p>\n","protected":false},"author":1,"featured_media":3415,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[22],"tags":[902,903,245,461,85,904],"class_list":["post-3534","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-veritabani","tag-alter","tag-guncelle","tag-sql-server","tag-t-sql","tag-transact-sql","tag-veri-tabani"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/3534","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/comments?post=3534"}],"version-history":[{"count":0,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/3534\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/media\/3415"}],"wp:attachment":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/media?parent=3534"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/categories?post=3534"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/tags?post=3534"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}