HOBALL 筆記簿

July 23, 2008

MySQL – Show Tables in a Database

Filed under: SQL — Tags: , , — hoball @ 2:17 pm

To show all the tables in a selected database (currently working):

SHOW TABLES;

To show all the tables in ANOTHER database:

SHOW TABLES IN other_database;

To show a table who you forget the exact name, you may use the wildcard(%):

SHOW TABLES IN other_database LIKE “%salary%;

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: