Posted on 1998-10-23
I have been struggling to find a way to query any type of table (Access, Oracle, DBase, etc.) to find what tables it contains. I know that Access has a nice command CDaoTables, but this works only for Access dbs. There is suppose to be a command SQLTables, but I can't get it to work correctly. There is also suppose to be an sp_tables, but that is only for MS SQL Server and the situations where my program is suppose to work do not guarantee any individual server or database.
THUS, is there a standard way of getting the table information during run-time for a database that will work for all database situations? I would prefer if I can send it using a normal SQL statement. Also if possible please show a sample of the code.