查询某张表的表结构

SELECT d.name tablename,a.name columnname,b.name bytename,a.length,(case when b.name='int' then 4 else COLUMNPROPERTY(a.id,a.name,'PRECISION') end) byte,isnull(COLUMNPROPERTY(a.id,a.name,'Scale'),0) dot
FROM syscolumns a left join systypes b 
on a.xtype=b.xusertype
inner join sysobjects d 
on a.id=d.id and d.xtype='U' and d.name<>'dtproperties' where d.name='GoodsTable'