{"id":2974,"date":"2022-05-09T06:00:25","date_gmt":"2022-05-08T21:00:25","guid":{"rendered":"https:\/\/www.oqiita.com\/?p=2974"},"modified":"2022-05-09T06:00:25","modified_gmt":"2022-05-08T21:00:25","slug":"%e3%80%90sqlserver%e3%80%91%e3%83%86%e3%83%bc%e3%83%96%e3%83%ab%e4%b8%80%e8%a6%a7%e3%80%81%e3%82%ab%e3%83%a9%e3%83%a0%e4%b8%80%e8%a6%a7","status":"publish","type":"post","link":"https:\/\/www.oqiita.com\/?p=2974","title":{"rendered":"\u3010SQLServer\u3011\u30c6\u30fc\u30d6\u30eb\u4e00\u89a7\u3001\u30ab\u30e9\u30e0\u4e00\u89a7"},"content":{"rendered":"<p>SQLServer\u30e1\u30e2<\/p>\n<p><!--more--><\/p>\n<p><\/p>\n<h3 id=\"i-0\">\u30c6\u30fc\u30d6\u30eb\u4e00\u89a7\uff08\u30b3\u30e1\u30f3\u30c8\u4ed8\u304d\uff09<\/h3>\n<pre class=\"line-numbers\"><code class=\"language-sql\">SELECT\n    systab.name AS \u30c6\u30fc\u30d6\u30eb\u540d\n    , sysex.value AS \u30b3\u30e1\u30f3\u30c8 \nFROM\n    sys.tables systab \n    RIGHT OUTER JOIN sys.extended_properties sysex \n        ON systab.object_id = sysex.major_id \n        AND sysex.minor_id = 0 \nWHERE\n    systab.name LIKE '%' -- \u30c6\u30fc\u30d6\u30eb\u540d\u3067\u7d5e\u308a\u8fbc\u307f\nORDER BY\n    systab.object_id\n;\n<\/code><\/pre>\n<h3 id=\"i-1\">\u30ab\u30e9\u30e0\u4e00\u89a7\uff08\u30b3\u30e1\u30f3\u30c8\u4ed8\u304d\uff09<\/h3>\n<pre class=\"line-numbers\"><code class=\"language-sql\">SELECT\n    syscol.name AS \u30ab\u30e9\u30e0\u540d\n    , sysex.value AS \u30b3\u30e1\u30f3\u30c8 \nFROM\n    sys.columns syscol\n    LEFT JOIN sys.extended_properties sysex \n        ON syscol.object_id = sysex.major_id \n        AND syscol.column_id = sysex.minor_id \nWHERE\n    object_id in ( \n        SELECT\n            systab.object_id \n        FROM\n            sys.tables systab\n        WHERE\n            systab.name LIKE 'TEST' -- \u30c6\u30fc\u30d6\u30eb\u540d\u3067\u7d5e\u308a\u8fbc\u307f\n    )\nORDER BY \n    syscol.column_id\n;\n<\/code><\/pre>\n<h3 id=\"i-2\">\u307e\u3068\u3081<\/h3>\n<p>\u6bce\u56de\u8abf\u3079\u308b\u306e\u3081\u3093\u3069\u3044<\/p>\n<p>\u4ee5\u4e0a<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SQLServer\u30e1\u30e2<\/p>\n","protected":false},"author":1,"featured_media":733,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[90],"tags":[],"class_list":{"0":"post-2974","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-db","8":"entry"},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/www.oqiita.com\/wp-content\/uploads\/2018\/05\/sango_db_icatch.png","jetpack_shortlink":"https:\/\/wp.me\/p8QluP-LY","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.oqiita.com\/index.php?rest_route=\/wp\/v2\/posts\/2974","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.oqiita.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.oqiita.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.oqiita.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.oqiita.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2974"}],"version-history":[{"count":3,"href":"https:\/\/www.oqiita.com\/index.php?rest_route=\/wp\/v2\/posts\/2974\/revisions"}],"predecessor-version":[{"id":2977,"href":"https:\/\/www.oqiita.com\/index.php?rest_route=\/wp\/v2\/posts\/2974\/revisions\/2977"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.oqiita.com\/index.php?rest_route=\/wp\/v2\/media\/733"}],"wp:attachment":[{"href":"https:\/\/www.oqiita.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2974"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.oqiita.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2974"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.oqiita.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2974"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}