mysql -e 'SHOW TABLES;' mydb

Category: Databases & SQL

mysql -e 'SHOW TABLES;' mydb

List tables in a database

One-shot listing of every table and view in mydb; interactive sessions can run SHOW TABLES directly at the prompt. Related: DESCRIBE users for columns.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.