-- SQL 2005 and later SELECT COUNT(*) FROM sys.tables -- SQL 2000 and later SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE'