To count total number of table in database.

Posted by Virendradugar under Sql Server category on 9/18/2009 | Views : 2870

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

Bookmark It

Latest Code Snipptes