一个简化版的表列数据

select
tableName=a.name,--表名
columnName=b.name,--列名
columnType=e.name,--列的数据类型
columnLength=b.max_length,--列的数据长度
--columnDefault=d.definition,--列的默认值
columnNote=c.value--列的注释
from sys.objects a
inner join
sys.columns b
on a.object_id=b.object_id
inner join
sys.extended_properties c
on a.object_id=c.major_id and b.column_id=c.minor_id
inner join
sys.types e
on b.system_type_id=e.system_type_id
where a.type='U' and a.name='tb_User'

转载于:https://www.cnblogs.com/zhulinmails/archive/2012/05/25/2518636.html