查询某张表的表结构

最新推荐文章于 2024-11-22 17:05:31 发布

weixin_30420305

最新推荐文章于 2024-11-22 17:05:31 发布

阅读量266

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/myblogslh/p/4363530.html

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'

转载于:https://www.cnblogs.com/myblogslh/p/4363530.html