Kbase P19151: How to get schema information using SQL89 ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/02/2003 |
|
Status: Unverified
GOAL:
How to get schema information using SQL89 ?
FACT(s) (Environment):
Progress 9.1x
FACT(s) (Environment):
Progress 8.3x
FIX:
You can use this statement to gather information about the fields of a table :
SELECT _file-name,_field-name FROM _file, _field
WHERE _file-number > 0 AND _field._file-recid = RECID(_file)
This statement only works from the Progress Editor which only support SQL89.