Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.
Moderator: General Moderators
emmbec
Forum Contributor
Posts: 112 Joined: Thu Sep 21, 2006 12:19 pm
Location: Queretaro, Mexico
Post
by emmbec » Mon May 07, 2007 2:21 pm
Hi, is there a query to get all the tables inside a DB??? Can anyone tell me how this query looks like???
Thanks
pickle
Briney Mod
Posts: 6445 Joined: Mon Jan 19, 2004 6:11 pm
Location: 53.01N x 112.48W
Contact:
Post
by pickle » Mon May 07, 2007 2:35 pm
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.
emmbec
Forum Contributor
Posts: 112 Joined: Thu Sep 21, 2006 12:19 pm
Location: Queretaro, Mexico
Post
by emmbec » Mon May 07, 2007 2:47 pm
I am using MySQL, thanx a lot, the SHOW TABLES command solved my problems!
pickle
Briney Mod
Posts: 6445 Joined: Mon Jan 19, 2004 6:11 pm
Location: 53.01N x 112.48W
Contact:
Post
by pickle » Mon May 07, 2007 2:52 pm
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
Real programmers don't comment their code. If it was hard to write, it should be hard to understand.