How to Count number of Tables in a Sql Server Database?

 Posted by Vishalneeraj-24503 on 3/1/2015 | Category: Sql Server Interview questions | Views: 364 | Points: 40
Answer:

select count(*) from information_schema.tables

where table_type = 'base table';


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response