SQL Server系统视图 [不定期更新]

2.查看用户表的字段说明信息：

<span style="color: #0000ff;">select</span><span style="color: #000000;"> 
    表名</span><span style="color: #808080;">=</span><span style="color: #ff00ff;">case</span> <span style="color: #0000ff;">when</span> col.column_id<span style="color: #808080;">=</span><span style="color: #800000; font-weight: bold;">1</span> <span style="color: #0000ff;">THEN</span> tab.name <span style="color: #0000ff;">else</span> N<span style="color: #ff0000;">‘‘</span> <span style="color: #0000ff;">end</span><span style="color: #000000;">, 
    字段名</span><span style="color: #808080;">=</span><span style="color: #000000;">col.name,
    字段说明</span><span style="color: #808080;">=</span><span style="color: #ff00ff;">isnull</span>(ext.value,N<span style="color: #ff0000;">‘‘</span><span style="color: #000000;">)
</span><span style="color: #0000ff;">from</span><span style="color: #000000;"> sys.tables tab 
    </span><span style="color: #808080;">join</span><span style="color: #000000;"> sys.columns col 
        </span><span style="color: #0000ff;">on</span> tab.<span style="color: #ff00ff;">object_id</span><span style="color: #808080;">=</span>col.<span style="color: #ff00ff;">object_id</span>
    <span style="color: #808080;">join</span><span style="color: #000000;"> sys.extended_properties ext 
        </span><span style="color: #0000ff;">on</span> col.<span style="color: #ff00ff;">object_id</span><span style="color: #808080;">=</span>ext.major_id <span style="color: #808080;">and</span> col.column_id<span style="color: #808080;">=</span>ext.minor_id

SQL Server系统视图 [不定期更新]

标签：