{"published":"2010-11-10 16:29:23","provider_name":"Hatena Blog","blog_url":"https://blog.jhashimoto.net/","image_url":"http://capture.heartrails.com/150x130/shadow?http://point56.blogspot.jp/2007/06/sql-server-2005-sql-server.html","url":"https://blog.jhashimoto.net/entry/20101110/1289374163","width":"100%","provider_url":"https://hatena.blog","blog_title":"Architect's Log","author_name":"JHashimoto","height":"190","description":"\u9069\u5f53\u306b\u30ab\u30b9\u30bf\u30de\u30a4\u30ba\u3057\u3066\u3001\u30c6\u30fc\u30d6\u30eb\u5b9a\u7fa9\u66f8\u306e\u4f5c\u6210\u7b49\u306b\u304a\u4f7f\u3044\u304f\u3060\u3055\u3044\u3002 \u5bfe\u5fdc\u30d0\u30fc\u30b8\u30e7\u30f3 SQL Server 2005, 2008 R2\u3067\u52d5\u4f5c\u78ba\u8a8d\u6e08\u307f\u30022008\u3067\u3082\u52d5\u304f\u3068\u601d\u3044\u307e\u3059\u3002 \u30c6\u30fc\u30d6\u30eb\u3001\u30d3\u30e5\u30fc\u306e\u4e00\u89a7 SELECT TABLE_CATALOG ,TABLE_SCHEMA ,TABLE_NAME ,TABLE_TYPE FROM INFORMATION_SCHEMA.TABLES ORDER BY TABLE_SCHEMA ,TABLE_NAME ,TABLE_TYPE \u30c6\u30fc\u30d6\u30eb\u5b9a\u7fa9 \u30af\u30a8\u30ea\u5148\u982d\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d\u3001\u30b9\u30ad\u30fc\u30de\u540d\u3001\u30c6\u30fc\u30d6\u30eb\u540d\u3092\u5909\u66f4\u3057\u3066\u304f\u3060\u3055\u3044\u3002\uff08Null\u306b\u3059\u308b\u3068\u6761\u4ef6\u306a\u3057\u306b\u306a\u308a\u307e\u3059\uff09 DE\u2026","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fblog.jhashimoto.net%2Fentry%2F20101110%2F1289374163\" title=\"\u30c6\u30fc\u30d6\u30eb\u5b9a\u7fa9\u53d6\u5f97\u30af\u30a8\u30ea - Architect&#39;s Log\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","type":"rich","version":"1.0","categories":["SQL Server"],"title":"\u30c6\u30fc\u30d6\u30eb\u5b9a\u7fa9\u53d6\u5f97\u30af\u30a8\u30ea","author_url":"https://blog.hatena.ne.jp/JHashimoto/"}