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

Natively, I use adbobjects() and or the SQL depending on what I am after [like you, when I need to do a self-join].