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