SHOW TABLES Syntax in MySQL

Posted by admin
May 6, 2008

SHOW [OPEN] TABLES [FROM db_name] [LIKE ‘pattern’]

SHOW TABLES lists the non-TEMPORARY tables in a given database. You can also get this list
using the mysqlshow db_name command.

Note: If you have no privileges for a table, the table will not show up in the output from
SHOW TABLES or mysqlshow db_name.

SHOW OPEN TABLES lists the tables that are currently open in the table cache. The Comment
field in the output tells how many times the table is cached and in_use. OPEN can be used
from MySQL 3.23.33 on.

Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google
  • Live
  • YahooMyWeb
  • Yigg
Database

If you enjoyed this post, please consider to leave a comment or subscribe to the feed and get future articles delivered to your feed reader.

Comments

No comments yet.

Leave a comment

(required)

(required)