Kbase P159499: How to list SQL SYNONYMs of a database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2010 |
|
Status: Unverified
GOAL:
How to list SQL SYNONYMs of a database
GOAL:
How to find out more information about synonyms
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.1x
OpenEdge 10.x
FIX:
Using SQL explorer:
select * from sysprogress.syssynonyms;
Using 4GL client:
FOR EACH _Syssynonyms NO-LOCK:
DISPLAY _Sname _Sowner _Screator _Stbl _Stblowner _Sremdb.
END.