I was wondering if there is a way to get the names of tables in a database using an SQL statement. I am trying to keep it database independent so it can be used with any ODBC data source. If there is not a way to do this for all database, I would like to see an example using ADO and MS Access.

Thanks in advance,