Count number of Tables in a database

Posted by Akiii under Sql Server category on 7/30/2012 | Points: 40 | Views : 2047

USE YOURDBNAME
SELECT COUNT(*) from information_schema.tables
WHERE table_type = 'base table'

Thanks and Regards
Akiii

Bookmark It

Latest Code Snipptes