MySQL :: MySQL 8.4 Reference Manual :: 15.7.7.39 SHOW TABLES Statement (original) (raw)

15.7.7.39 SHOW TABLES Statement

SHOW [EXTENDED] [FULL] TABLES
    [{FROM | IN} db_name]
    [LIKE 'pattern' | WHERE expr]

SHOW TABLES lists the non-TEMPORARY tables in a given database. You can also get this list using the mysqlshow_db_name_ command. TheLIKE clause, if present, indicates which table names to match. The WHERE clause can be given to select rows using more general conditions, as discussed in Section 28.8, “Extensions to SHOW Statements”.

Matching performed by the LIKE clause is dependent on the setting of thelower_case_table_names system variable.

The optional EXTENDED modifier causesSHOW TABLES to list hidden tables created by failed ALTER TABLE statements. These temporary tables have names beginning with#sql and can be dropped usingDROP TABLE.

This statement also lists any views in the database. The optional FULL modifier causesSHOW 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 or mysqlshow db_name.

Table information is also available from theINFORMATION_SCHEMA TABLES table. SeeSection 28.3.38, “The INFORMATION_SCHEMA TABLES Table”.