Count number of Tables in a database

Akiii
Posted by Akiii under Sql Server category on | Points: 40 | Views : 1004
USE YOURDBNAME
SELECT COUNT(*) from information_schema.tables
WHERE table_type = 'base table'




Thanks and Regards
Akiii

Comments or Responses

Login to post response