Selects / Displays all the tables that are present in the data base from all the data bases;
SELECT *
FROM information_schema.Tables;
Use this following command for more precise data.
SELECT *
FROM information_schema.Tables;
Use this following command for more precise data.
SELECT table_name, table_type, engine
->FROM information_schema.tables
->WHERE table_schema = 'db5'
->ORDER BY table_name DESC;