{"blog_url":"https://kkkw.hatenablog.jp/","version":"1.0","categories":["SQL","SQL Server"],"author_name":"devillikeaangel","published":"2008-08-14 00:57:48","provider_name":"Hatena Blog","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fkkkw.hatenablog.jp%2Fentry%2F20080814%2F1218643068\" title=\"\u30ab\u30e9\u30e0\u306e\u30b3\u30e1\u30f3\u30c8\u3092\u53d6\u5f97\u3059\u308bSQL - kikukawa&#39;s diary\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","provider_url":"https://hatena.blog","author_url":"https://blog.hatena.ne.jp/devillikeaangel/","description":"SqlServer \u30ab\u30e9\u30e0\u306e\u30b3\u30e1\u30f3\u30c8\u3092\u53d6\u5f97\u3059\u308bSQL SELECT T.NAME AS TABLE_NAME, C.NAME AS COLUMN_NAME, EP.VALUE AS COMMENT FROM SYS.TABLES T, SYS.COLUMNS C, SYS.EXTENDED_PROPERTIES EP WHERE T.NAME = 'TEST_TABLE' AND T.OBJECT_ID = C.OBJECT_ID AND C.OBJECT_ID = EP.MAJOR_ID AND C.COLUMN_ID = EP.MINOR_ID ;","width":"100%","blog_title":"kikukawa's diary","type":"rich","url":"https://kkkw.hatenablog.jp/entry/20080814/1218643068","height":"190","title":"\u30ab\u30e9\u30e0\u306e\u30b3\u30e1\u30f3\u30c8\u3092\u53d6\u5f97\u3059\u308bSQL","image_url":null}