mysql see all tables in database code example
Example 1: mysql command show tables
SHOW TABLES;
Example 2: mysql check all tables
mysqlcheck -c mydatabasename -u root -p
SHOW TABLES;
mysqlcheck -c mydatabasename -u root -p