Page 1 of 1

select tables from MySQL Database

Posted: Mon May 07, 2007 2:21 pm
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

Posted: Mon May 07, 2007 2:35 pm
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.

Posted: Mon May 07, 2007 2:47 pm
by emmbec
I am using MySQL, thanx a lot, the SHOW TABLES command solved my problems!

Posted: Mon May 07, 2007 2:52 pm
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: