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
