MySQL information_schema tables come in to help on this. It keeps a record on each and every Schema Creations and updates.
To fetch the above statistics for the required schema, following query can be executed,
Related Articles
SELECT * FROM information_schema.TABLES WHERE TABLE_SCHEMA = "location_app";
SCHEMA() function on MySQL returns the currently selected schema, so it is possible to use that straightaway.
SELECT * FROM information_schema.TABLES WHERE TABLE_SCHEMA = SCHEMA();
More importantly, it is possible to set a specific table name as well.
References
https://dev.mysql.com/doc/refman/8.0/en/