>>>VFP:
>>>
>>>

** lnHandle would be the handle returned from a good SQLCONNECT() call
>>>* tables
>>>SQLEXEC(lnHandle, "SELECT objectname FROM DBC() WHERE objecttype = 'Table' ORDER BY objectname", "vfptables")
>>>
>>>* views
>>>SQLEXEC(lnHandle, "SELECT objectname FROM DBC() WHERE objecttype = 'View' ORDER BY objectname", "vfpviews")

>>
>>Son of a buck, that does work. I knew you could run a query against the DBC, but I would not have thought FROM DBC() would work.
>
>I do it all the time in VFP to get all table and field names (by self joining) but I wasn't sure it would work through ODBC - but I tried it and whaddya know <g>

Trey,

it is wonderfull idea.

Any idea with other Database as SQL, Oracle, Access ?