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