how to get all schema list in progress-openedge SQL query

Question

How to get schema list in Progress OpenEdge SQL query for PUB and SYSPROGRESS:

Schema

In this case

Schema Names

Or for below structure.

Sports2000
  ↳ PUB
     ↳ Tables
  ↳ SYSPROGRESS
     ↳ Tables

Does this answer your question? What is the query for getting database name in Progress-OpenEdge? — Tom Bascom
– Tom Bascom, Commented May 12, 2021 at 18:30

Stefan Drissen · Accepted Answer · 2021-05-19 14:05:34Z

0

The schema you are referring to is the owner.

select owner, count(*) as '#' from sysprogress.systables group by owner

Which will return something like:

OWNER       #
PUB         157
SPORTS2020    1
SYSPROGRESS  49

answered May 19, 2021 at 14:05

Stefan Drissen

3,4021 gold badge15 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1