SQL 查詢Table表的結構

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
inner join sysobjects d
on c.id = d.id and d.xtype='U' and d.name = 'TableName'