sqlserver查询表字段的名称，描述，数据类型，长度

SELECT

B.name AS column_name,

case when d.NUMERIC_PRECISION is not null and (d.data_type='decimal' or d.data_type='numeric') then
                d.data_type+'('+cast(d.NUMERIC_PRECISION as varchar)+','+cast(d.NUMERIC_SCALE as varchar)+')'
            when  d.CHARACTER_MAXIMUM_LENGTH is not null then
                d.data_type+'('+cast(d.CHARACTER_MAXIMUM_LENGTH as varchar)+')'
            else
                d.data_type
       end as data_type,

case when d.is_nullable='YES' then '' else 'NO' end as  nullable,

C.value AS column_description

FROM sys.tables A
INNER JOIN sys.columns B ON B.object_id = A.object_id
LEFT JOIN sys.extended_properties C ON C.major_id = B.object_id AND C.minor_id = B.column_id
inner join information_schema.columns D on a.name=d.table_name  and B.name=d.column_name
WHERE A.name = 'test_hts_analysis'
order by d.ordinal_position