This is a very Simple query to find the number of tables present in a purticular schema of the database
select information_schema as your default schema and use the following query to find the count of number of tables in a particular schema
SELECT count(*) FROM 'TABLES' WHERE TABLE_SCHEMA = 'YOUR_SCHEMA_NAME*'
*YOUR_SCHEMA_NAME = NAME OF THE SCHEMA TO WHICH YOU ARE FINDING THE COUNT
select information_schema as your default schema and use the following query to find the count of number of tables in a particular schema
SELECT count(*) FROM 'TABLES' WHERE TABLE_SCHEMA = 'YOUR_SCHEMA_NAME*'
*YOUR_SCHEMA_NAME = NAME OF THE SCHEMA TO WHICH YOU ARE FINDING THE COUNT
