Kbase P43044: SQL: How to display a Progress database table information using SQL?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/30/2008 |
|
Status: Unverified
GOAL:
SQL: How to display a Progress database table information using SQL?
GOAL:
How to list table names of a Progress database using SQL?
GOAL:
How to list the User Data Tables names and other information of a Progress database using SQL?
GOAL:
How to list the Virtual System Tables (VST) names and other information of a Progress database using SQL?
GOAL:
How to list the SQL Schema Tables names and other information of a Progress database using SQL?
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
There are three types of tables in a Progress database: User Data Tables, Virtual System Tables and SQL Schema Tables.
1. To list the User Data Tables use the SQL statement:
SELECT * FROM PUB."_File" where "_Tbl-Type" = 'T'
2. To list the Virtual System Tables use the SQL statement:
SELECT * FROM PUB."_File" where "_Tbl-Type" = 'S'
3. To list the SQL Schema Tables use the SQL statement:
SELECT * FROM PUB."_File" where "_Tbl-Type" = 'V'
4. To list all the database tables, regardless of type, use the SQL statement:
SELECT * FROM PUB."_File"