> I know I have seen this on the list before but I can't find the exact code.
> Does anyone have the code for querying a database and returning a list of
> tables and/or column info?
If your database is compliant with the SQL spec you can get all
off that from the information schema:
SELECT * FROM INFORMATION_SCHEMA.TABLES;
SELECT * FROM INFORMATION_SCHEMA.COLUMNS;
Jochem
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
