Retreiving all tablenames

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Shendemiar
Forum Contributor
Posts: 404
Joined: Thu Jan 08, 2004 8:28 am

Retreiving all tablenames

Post by Shendemiar »

Is there a way to query list of tablenames from mysql?
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post by RobertGonzalez »

Code: Select all

SHOW TABLES;
Shendemiar
Forum Contributor
Posts: 404
Joined: Thu Jan 08, 2004 8:28 am

Post by Shendemiar »

Everah wrote:

Code: Select all

SHOW TABLES;
Thanks...

I find the MySql website and manual very difficult to use thus unhelpful.
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post by RobertGonzalez »

I did too at first. But once you start learning how it is set up, you start figuring out how to ask it questions.

PS phpMyAdmin is a great way to learn some useful queries as it relates to your mysql server.
Post Reply