SELECT
 表名,
 字段名,
 字段类型,
g.VALUE 字段说明
FROM
syscolumns a
LEFT JOIN systypes b ON a.xtype = b.xusertype
INNER JOIN sysobjects d ON  = d.id AND d.xtype = 'U' AND  <> 'dtproperties'
LEFT JOIN sys.extended_properties g ON  = g.major_id
AND a.colid = g.minor_id
where
 ='数据表名'

数据库 - 使用navicat 导出Sql Server类型数据库表结构_表名