获取表字段名称 、类型、说明

 

SELECT 
t2.table_name,
t2.column_name,
t1.[type],
t2.column_description 
FROM (
select 
syscolumns.name,
systypes.name+'('+cast(syscolumns.length/2 as varchar(10))+')' [type],
syscolumns.length 
from syscolumns,systypes
where syscolumns.xusertype=systypes.xusertype and syscolumns.id=object_id('表名')
) t1
LEFT JOIN 
(
SELECT A.name AS table_name, B.name AS column_name, C.value AS column_description
FROM sys.tables AS A 
INNER JOIN sys.columns AS B ON B.object_id = A.object_id 
LEFT OUTER JOIN sys.extended_properties AS C ON C.major_id = B.object_id AND C.minor_id = B.column_id
WHERE (A.name = '表名')
) t2 ON t1.name=t2.column_name