Kbase P125518: How do I know what table in my database has what number?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/22/2008 |
|
Status: Verified
GOAL:
How do I know what table in my database has what number?
GOAL:
ABL/4GL: How to list my database table names, numbers and other information?
GOAL:
How to map table names to table numbers?
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
The progress database table information is stored in the _file system table. For example, the following code snippet lists the USER data tables' names and numbers sorted by table name:
FOR EACH _file NO-LOCK WHERE _Tbl-Type = "T" BY _File-Name:
DISPLAY _file-Name _File-Number.
END.
And the following code snippet lists the name, number and type of ALL tables in the database. These include the user data tables, the system tables and the virtual system tables:
FOR EACH _file NO-LOCK BY _Tbl-Type BY _File-Name:
DISPLAY _file-Name _File-Number _Tbl-Type.
END.