select b.name,a.colid,a.name
,(select systypes.name+'('+cast(a.length/2 as varchar(10))+')' from systypes where a.xusertype=systypes.xusertype ) type
from syscolumns a
left outer join sysobjects b
on a.id=b.id
where b.xtype='U'
order by b.name,a.colid
SQL查询数据库中所有表、表字段名及数据类型
最新推荐文章于 2024-07-05 17:12:03 发布