Hi guys

A long shot, maybe, but is there any way that I can get details of all of the tables in a database by running a query?

The problem is this: I use an informix database hosted by a third party. They're happy for me to access however they're not very forthcoming with any sort of database design information so I don't know which columns are in which tables.

I know that if it were a sqlserver database I could run sp_help to get this sort of information however is there any query I can run in asp or vb that will give me this information?

ps, I've connected using ado.

Tar!