SHOW OPEN TABLES Syntax


SHOW OPEN TABLES lists the non-TEMPORARY tables that are currently open in the table cache. See , "How MariaDB 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 , "Extensions to SHOW Statements".

SHOW OPEN TABLES returns the following columns:

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

Retornar