SELECT
c.column_name,
c.data_type,
CONVERT(VARCHAR(50),g.value)AS column_comment,
c.ORDINAL_POSITION AS column_key,
''AS extra
FROM information_schema.columns c
LEFT JOIN sys.syscolumns a ON c.COLUMN_NAME=a.name AND c.ORDINAL_POSITION=a.colorder
inner join sys.sysobjects d on a.id=d.id and d.xtype='U' and d.name!='dtproperties'
left join sys.extended_properties g on a.id=g.major_id AND a.colid = g.minor_id
WHERE
TABLE_NAME = '数据表名称'
AND TABLE_CATALOG ='数据库名称'
ORDER BY ordinal_position