>>>>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 ?