show tables;
# First, select your database USE yourDb; # Then, simply SHOW TABLES;
SHOW TABLES;
mysql -u user -p
Press CTRL+C to copy SHOW [EXTENDED] [FULL] TABLES [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr]