Kbase P47496: SQL: How to identify the owner of a Progress database table using SQL-92?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/14/2008 |
|
Status: Unverified
GOAL:
SQL: How to identify the owner of a Progress database table using SQL-92?
GOAL:
Who owns what tables in a Progress database?
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
Executing the following SQL-92 statement returns all the tables in the Progress database along with related information that include the table owner:
SELECT * FROM SYSPROGRESS.SYSTABLES;