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