') else '' end,
字段序号=a.colorder,
字段名=a.name,
标识=case when COLUMNPROPERTY( a.id...=a.length,
长度=COLUMNPROPERTY(a.id,a.name,'PRECISION'),
小数位数=isnull(COLUMNPROPERTY(a.id,a.name...=e.id
left join sys.extended_properties g on a.id=g.major_id and a.colid=g.minor_id...left join sys.extended_properties f on d.id=f.major_id and f.minor_id=0
where d.name='T_B_POMS_COMPANY...' --如果只查询指定表,加上此条件
order by a.id,a.colorder