Question:

Database Administration. what are queries to find number of tables and number of views in a

by Guest7919  |  12 years, 9 month(s) ago

0 LIKES UnLike

what are queries to find number of tables and number of views in a database?

 Tags: administration, database

   Report
Answer The Question I've Same Question Too

1 ANSWERS

Sort By: Date  |  Rating
  1. Guest4175
    If you are using SQL Server then....

    Number of VIEWS in a Database:
    SELECT COUNT(*) from information_schema.tables
    WHERE table_type = 'base table'


    Number of VIEWS in a Database:
    SELECT COUNT(*) from information_schema.tables
    WHERE table_type = 'view'

Sign In or Sign Up now to answser this question!
You're reading: Database Administration. what are queries to find number of tables and number of views in a

Question Stats

Latest activity: 15 years, 1 month(s) ago.
This question has 1 answers.

BECOME A GUIDE

Share your knowledge and help people by answering questions.
Register Now