Count number of tables in a SQL Server database

Virendradugar
Posted by Virendradugar under Sql Server category on | Views : 2984
USE YOURDBNAME

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

Comments or Responses

Login to post response