You should be able to query the system table that holds that column names.
Not sure which it is tho.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf
Of G. Anthony Reina
Sent: Monday, September 11, 2000 4:38 PM
To: [EMAIL PROTECTED]
Subject: [SQL] How can I select all of the tables with field name
'area'?
I have a database with several tables. I'd like to pull out a list of
names for the tables that contain the field (class) name 'area'.
Can this be done?
-Tony