Shoutbox

I am trying to figure out what tables are available on a particular database. I have read access to the whole database, through an html form to input queries. Is it possible to query a list of available tables?

code:

---

example: Select * from BaseTable.Table where ....

---

I have BaseTable, I am trying to figure out all of the Table names

SHOW TABLES FROM DatabaseName

(That works in MySQL, anyway)

Error: your query must have a select statement.

there's a error detect in place, ya need a select and where clause

Well, I dunno if it's possible to list the tables if you can only run SELECT queries... hmm...

What is the database (e.g. MySQL, MS SQL) and what are you using to query it with?

Using MS SQL, you can select the table names from sysobjects system table -- I would have to look in the docs to see what you need in your where clause to limit the results to just tables (and not also views, etc).

its MySQL on a java/tomcat server

http://dev.mysql.com/doc/refman/5.0/en/information-schema.html

Unfortunately, with MySQL 4.x and older, you are out of luck if you can't use SHOW.

sorry to bring back a thread....

is it possible to embed this as a subquery? I tried
select * from (show tables from database where table is not null) where table is not null
but that gives a "no 'where' clause found" error