>>>I have a directly full of dbf tables (not attached to a dbc). Is there a way I can programmatically determine which tables have a column named "ifkey"?
>>>
>>>If not possible on a directory of free tables, would it be possible if they were attached to a DBC? How would you query this matter if they were atatched to a dbc?
>>
>>If all the tables are in a DBC........

>>SELECT cur1.objectname AS tablename ;
>>  FROM myDbc.dbc cur1;
>>     JOIN myDbc.dbc cur2 ON cur1.objectid = cur2.parentid;
>> WHERE cur2.objecttype = "Field" AND cur2.objectname = myFieldName

>>
>>If they're not in a DBC then try Naomi's loop
>
>A little more help from you?
>
>What would be the que query for "all tables that *do not* contain a field named [id]"?
>
>All tables are in a dbc.

select * from MyDBC cur1 where ObjectType = 'Table' ;
 and not exists (select 1 from myDBC cur2 where cur2.ObjectID = cur1.ParentID ;
and cur2.ObjectType = 'Field' and cur2.ObjectName = 'ID')

from the top of my head - you need to test.