Syntax:
SHOW OPEN TABLES [FROM db_name] [LIKE 'pattern']

SHOW OPEN TABLES lists the non-TEMPORARY tables that are currently open
in the table cache. See
http://dev.mysql.com/doc/refman/5.0/en/table-cache.html.

URL: http://dev.mysql.com/doc/refman/5.0/en/show-open-tables.html

