Kbase P24342: How to get a list of all the table names in the schema where
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/2/2003 |
|
Status: Unverified
GOAL:
How to get a list of all the table names in the schema where a particular field name exists?
FIX:
The following example can be run against the Sports2000 database to get a list of all tables in the schema that have "EmpNum" field.
FOR EACH _file, EACH _field OF _file
WHERE _field._field-name = "EmpNum".
IF SUBSTRING(_field._field-name, 1, 1) <> "_" THEN
DISPLAY _file._file-name _field._field-name.
To run this query against your database, simply substitute the desired fieldname ("EmpNum").