- Instant help with your Sql coding problems

List all tables in a MySQL database

by Mike
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

Reference:
SHOW TABLES reference
Share "How to list all tables in a MySQL database?"
Related snippets:
Tags:
list tables, show tables, list views, table, view, mysql
Technical term:
List all tables in a MySQL database
Trending snippets
Backup only certain rows from MySQL databaseGet last 30 days records in MySQLCreate INSERT statement for each record with mysqldumpBackup MySQL data onlyBackup MySQL database without locking tablesSkip tables in MySQL backupDelete all records from a table in MySQLCreate table in MySQLBackup MySQL schema onlyDelete records from MySQL tableBackup only selected tables in MySQLBackup MySQL databaseGet current year in MySQLSort MySQL resultsConvert INT to DATETIME in MySQLGroup by year of Unix timestamp in MySQLReturn 0 if field is NULL in MySQLList all tables in a MySQL databaseImport an SQL file using the command line in MySQLFind MySQL data directory location
Network articles
Convert kilometers to miles in JavaScriptUsing :not in TailwindCSSAdd CSS to content script in Manifest V3Create a 20/80 grid with Tailwind CSSSelect first child in TailwindCSSAdd class to multiple elements in JavaScriptGet multiple cursors in VS CodeExecute PHP script from command lineRemove specific character from a string in JavaScriptConvert string to pascal case in JavaScriptToggle fullscreen and normal mode with JavaScriptConvert object to JSON string in JavaScriptDuplicate line or selection in VS CodeRemove HTML tags from a string except p, b, i and br in PHPSetup HTTPS for local development on Windows 10Convert hexadecimal to decimal in PHPPHP array lengthSet custom cursor in CSSSetup Facebook Open Graph Meta TagsGet parameter from URL in JavaScript