读出sql表结构

领测软件测试网 select object_name(c.id) as 表名
 ,c.name as 字段名
 ,t.name 数据类型
        ,c.length 长度
 ,c.prec as 精度
 ,p.value as 字段说明
 ,m.text as 默认值
        ,case when c.status=0x80 then 1 else 0 end 标识
        ,c.iscomputed 是否已计算该列的标志
        ,c.isnullable 是否允许空值
        ,c.isoutparam 是否输出参数 
from    syscolumns c
        inner join systypes t on c.xusertype=t.xusertype
 left join sysproperties p on c.id=p.id and c.colid = p.smallid
 left join syscomments m on c.cdefault=m.id
where   objectproperty(c.id,‘’IsUserTable‘’)=1 and object_name(c.id)=‘’dat_deptinfo‘’

文章来源于领测软件测试网 https://www.ltesting.net/