获取数据库中用户表
select id,name from sysobjects where xtype='u'
获取某个表中的字段名和类型
select A.name,B.name as Type from syscolumns A
join systypes B on A.xtype=B.xusertype
where id = object_id('表名')
获取数据库中用户表
select id,name from sysobjects where xtype='u'
获取某个表中的字段名和类型
select A.name,B.name as Type from syscolumns A
join systypes B on A.xtype=B.xusertype
where id = object_id('表名')