Jump to content


Photo

Display All Table Names In A Database


  • Please log in to reply
2 replies to this topic

#1 zebe

zebe
  • Members
  • PipPip
  • Member
  • 24 posts

Posted 18 January 2006 - 07:14 PM

Hi,

Is there a mysql query that allows you to collect all the table names within a given database? I just want to print out all the table names.

Thanks for your help.

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 18 January 2006 - 07:30 PM

SHOW TABLES FROM yourDB

Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#3 zebe

zebe
  • Members
  • PipPip
  • Member
  • 24 posts

Posted 18 January 2006 - 07:31 PM

Easier than expected! Thanks!




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users