- Instant help with your Sql coding problems

List all tables in a MySQL database

Question:
How to list all tables in a MySQL database?
Answer:
SHOW TABLES;

-- With type TABLE oR VIEW
SHOW FULL TABLES;
Description:

SHOW TABLES lists the tables and views in a given database. The optional FULL modifier causes SHOW TABLES to display a second output column with values of BASE TABLE for a table, VIEW for a view, or SYSTEM VIEW for an INFORMATION_SCHEMA table.

If you have no privileges for a base table or view, it does not show up in the output from SHOW TABLES

Share "How to list all tables in a MySQL database?"
Tags:
list tables, show tables, list views, table, view, mysql
Technical term:
List all tables in a MySQL database