devillikeaangel https://blog.hatena.ne.jp/devillikeaangel/ kikukawa's diary https://kkkw.hatenablog.jp/ SQL SQL Server SqlServer カラムのコメントを取得するSQL 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 ; 190 <iframe src="https://hatenablog-parts.com/embed?url=https%3A%2F%2Fkkkw.hatenablog.jp%2Fentry%2F20080814%2F1218643068" title="カラムのコメントを取得するSQL - 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> Hatena Blog https://hatena.blog 2008-08-14 00:57:48 rich https://kkkw.hatenablog.jp/entry/20080814/1218643068 1.0 100%