select tables from MySQL Database

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
User avatar
emmbec
Forum Contributor
Posts: 112
Joined: Thu Sep 21, 2006 12:19 pm
Location: Queretaro, Mexico

select tables from MySQL Database

Post by emmbec »

Hi, is there a query to get all the tables inside a DB??? Can anyone tell me how this query looks like???

Thanks
User avatar
pickle
Briney Mod
Posts: 6445
Joined: Mon Jan 19, 2004 6:11 pm
Location: 53.01N x 112.48W
Contact:

Post by pickle »

What database are you using? Have you done any research?

In MySQL: SHOW TABLES
Postgres: \d

Not sure about other ones. I'm sure whatever DB you're using has documentation on that.
Real programmers don't comment their code. If it was hard to write, it should be hard to understand.
User avatar
emmbec
Forum Contributor
Posts: 112
Joined: Thu Sep 21, 2006 12:19 pm
Location: Queretaro, Mexico

Post by emmbec »

I am using MySQL, thanx a lot, the SHOW TABLES command solved my problems!
User avatar
pickle
Briney Mod
Posts: 6445
Joined: Mon Jan 19, 2004 6:11 pm
Location: 53.01N x 112.48W
Contact:

Post by pickle »

My apologies for the comment about what database you were using. Perhaps if I took 1.5 seconds to actually read the subject, I might have figured it out :oops:
Real programmers don't comment their code. If it was hard to write, it should be hard to understand.
Post Reply