--用户表的个数
select * from sysobjects where xtype='u'
select count(*) from sysobjects where xtype='u'
--表的详细信息
select   *   from   syscolumns   where   id=object_id('表名')
select   count(*)   from   syscolumns   where   id=object_id('表名')