MySQL 8.0 Reference Manual Including MySQL NDB Cluster 8.0 SHOW OPEN TABLES Statement

    [{FROM | IN} db_name]
    [LIKE 'pattern' | WHERE expr]

SHOW OPEN TABLES lists the non-TEMPORARY tables that are currently open in the table cache. See Section, “How MySQL Opens and Closes Tables”. The FROM clause, if present, restricts the tables shown to those present in the db_name database. The LIKE 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 26.55, “Extensions to SHOW Statements”.

SHOW OPEN TABLES output has these columns:

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