SqlServer/MySql查詢某個數據庫中表的數量

SqlServer/MySql查詢某個數據庫中表的數量   MySql的統計方法  

SELECT count( * ) FROM information_schema.tables WHERE TABLE_SCHEMA = '庫名'

select count(*) as TableCount from 

sysobjects where type='u' and status>=0