查询数据库表字段的说明

最新推荐文章于 2024-08-28 09:53:29 发布

weixin_33935777

最新推荐文章于 2024-08-28 09:53:29 发布

阅读量1.1k

点赞数

文章标签：数据库 javascript 开发工具 ViewUI

原文链接：http://www.cnblogs.com/focuses/archive/2011/12/27/2303836.html

版权

--查询语句

SELECT
    [Table Name] = OBJECT_NAME(col.object_id),
    [Column Name] = col.name,
    [Description] = ex.value
FROM
    sys.columns col
LEFT OUTER JOIN
    sys.extended_properties ex
ON
    ex.major_id = col.object_id
    AND ex.minor_id = col.column_id
    AND ex.name = 'MS_Description'
WHERE
    OBJECTPROPERTY(col.object_id, 'IsMsShipped')=0
     AND OBJECT_NAME(col.object_id) = 'UnitData'
ORDER
    BY OBJECT_NAME(col.object_id), col.column_id

--查询结果：

Table Name Column Name Description
UnitData Id 自增Id
UnitData UnitId 商铺Id
UnitData SortNo 序号

转载于:https://www.cnblogs.com/focuses/archive/2011/12/27/2303836.html