Hi!

I want to get a listing of tables and their fields given a DSN.
I will be using ADO library
I have got a listing of tables using OpenSchema method of connection.
But i don't know how to get a listing of field names in a table.
Present i am doing Select * from table_name for each table
But this will harm the performance and maytake a long time in case of large
number of tables
Can someone suggest a differnt method
I want the method to be database independent

Thanx and Regards
Vijay