HomePage
Jobs
WalkIn
Articles
Group Chat
Contact Us
Feedback
Sitemap
To improves our performance please Like Share Subscribe(Will boost us)
Follow
How to count number of table in database
Question Posted on 10 Feb 2012
Home
>>
DataBase
>>
SQL Query
>>
How to count number of table in database
Below is the query to get number of table in database:-
select count(*) TotalTable FROM Databasename.INFORMATION_SCHEMA.TABLES where TABLE_TYPE='BASE TABLE'
0
0
.
Most Visited Questions:-
Deep Learning Questions Answers
Below are the different Deep Leaning Questions and answer a
More...
Continuous Integration Questions Answers
Below are the 20 odd questions for CI or Continuous Integra
More...
Derived relationships in Association Rule Mining are represented in the form of __________.
Derived relationships in Association Rule Mining are repres
More...
What is Gulpjs and some multiple choice questions on Gulp
Gulpjs is an open source whihc helps in building Javascript
More...
Microservices Architecture Questions Answers
Below are the different questions on Microservices Architec
More...
Other Important Questions
How to get the table count in last used query from cache by sending tablename?
Write a SQL query to print 1 to 100 in sql server?
Sql Interview Latest Query questions asked on 30 dec 2020
nth highest number from table
some good sql query
@2014-2022 Crackyourinterview (All rights reserved)
Privacy Policy - Disclaimer - Sitemap