I have been using SQLObject for writing to a mysql database for a while now, and I am very happy with its very straightforward interface.

Now I want to do some queries and I am facing some problems:

My problem is as following:
I have database tables created before by SQLObject.
I Need to do the equivalent of a "show tables" SQL command to see what tables are available.
Get a list of strings with the names of the tables in my database. Select one of these and check which columns they have(get a list of column names).
I have no Idea of how to do this with SQLObject although this is a very basic thing in SQL.

can anyone tell me how to accomplish this with SQLObject?

thanks in advance,

--
Flávio Codeço Coelho
registered Linux user # 386432
---------------------------
Great spirits have always found violent opposition from mediocrities. The
latter cannot understand it when a man does not thoughtlessly submit to
hereditary prejudices but honestly and courageously uses his intelligence.
        Albert Einstein