Count Number of Tables in SQL Server Database

March 10, 2010 — Haripriya

USE YourDatabaseName

SELECT COUNT(*) from information_schema.tables
WHERE table_type = ‘base table’

Posted in Sql Tips. Leave a Comment »

Leave a comment

«

»