Below is a sample SQL query that demonstrates how to count the number of tables in a SQL Server database using information_schema.tables. How to Get the Number of Tables from SQL Server Database ? USE TrainingDB1 SELECT COUNT(*) as TableNos from information_schema.tables WHERE table_type = 'base table'
Related Posts :How to Get the List of User Tables in SQL Server?Open DBDiff for SQL Server 2008How to Specify port number for Server when connecting in SQL Management Studio ?What are the Limitations of SQL Server Express Edition ?How to Create a Database
Backup in SQL Server using SQL Scripts?...(Read whole news on source site)