{"id":3646,"date":"2016-03-05T22:37:54","date_gmt":"2016-03-05T22:37:54","guid":{"rendered":"http:\/\/www.gencayyildiz.com\/blog\/?p=3646"},"modified":"2016-03-05T22:37:54","modified_gmt":"2016-03-05T22:37:54","slug":"t-sql-ile-veritabanindaki-tablolari-listeleme","status":"publish","type":"post","link":"https:\/\/www.gencayyildiz.com\/blog\/t-sql-ile-veritabanindaki-tablolari-listeleme\/","title":{"rendered":"T-SQL \u0130le Veritaban\u0131ndaki Tablolar\u0131 Listeleme"},"content":{"rendered":"<div id=\"fb-root\"><\/div>\n<p>Transact SQL(T-SQL) ile \u00fczerinde \u00e7al\u0131\u015ft\u0131\u011f\u0131m\u0131z veritaban\u0131n\u0131n i\u00e7indeki tablolalar\u0131 \u00f6zellikleriyle birlikte elde etmek istiyorsan\u0131z a\u015fa\u011f\u0131daki komutlardan birini kullanabilirsiniz.<\/p>\n<pre class=\"brush: jscript; title: ; notranslate\" title=\"\">\r\nSelect * from sys.tables\r\n<\/pre>\n<p>ya da<\/p>\n<pre class=\"brush: jscript; title: ; notranslate\" title=\"\">\r\nSelect * from sysobjects WHERE xtype='U'\r\n<\/pre>\n<p>Bu iki sorguda sizlere tablo halinde veritaban\u0131n\u0131zdaki t\u00fcm tablolar\u0131n bilgilerini getirecektir.<br \/>\n\u0130yi \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>Transact SQL(T-SQL) ile \u00fczerinde \u00e7al\u0131\u015ft\u0131\u011f\u0131m\u0131z veritaban\u0131n\u0131n i\u00e7indeki tablolalar\u0131 \u00f6zellikleriyle birlikte elde etmek istiyorsan\u0131z a\u015fa\u011f\u0131daki komutlardan birini kullanabilirsiniz. Select * from sys.tables ya da Select * from sysobjects WHERE xtype=&#8217;U&#8217; Bu iki sorguda sizlere tablo&#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":[75,919,920,461,918,85],"class_list":["post-3646","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-veritabani","tag-select","tag-sys-tables","tag-sysobjects","tag-t-sql","tag-tablo","tag-transact-sql"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/3646","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=3646"}],"version-history":[{"count":0,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/3646\/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=3646"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/categories?post=3646"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/tags?post=3646"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}