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: 1181 | Points: 40

Answer:

select count(*) from information_schema.tables

where table_type = 'base table';

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : How to Redirect Page permanently with status code ...

Next > : What is an alternate way to List All Tables of Dat ...

More Interview Questions by Vishalneeraj-24503

Latest Interview Questions