统计 SQLServer中有多少张表

use myDBName     --欲统计的数据库
select count(*) as TableCount 
from sysobjects 
where type='u' and status>=0