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).
