Count number of tables in a SQL Server database
USE YOURDBNAME
SELECT COUNT(*) from information_schema.tables
WHERE table_type = 'base table'
Showing posts with label Count number of tables in a SQL Server database. Show all posts
Showing posts with label Count number of tables in a SQL Server database. Show all posts
15 September 2010
Subscribe to:
Posts (Atom)