How to find name of all tables in MySQL database| show all table names in mysql.

Get all Table name in mysql database

Using SHOW TABLES

SHOW TABLES;

OR

SHOW TABLES IN Db_name;

Screen shot:

Using information_schema:

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'information_schema';

Screen Shot: