Any SQL query to get the number of tables in a database?

Answer 1

Femi SONI Y
The sql query to find number of table present in database is written like this way

SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'dbName';

Where:-
Count - MySQL function which return count of any element.
* -> is stand for all
Information schema-> provide information about DB

Answer 2

Thanks I will try it.