title: how to get all schema list in progress-openedge SQL query
body: <p>How to get schema list in Progress OpenEdge SQL query for <strong>PUB</strong> and <strong>SYSPROGRESS</strong>:</p>
  <p><img src="https://i.stack.imgur.com/Ks0tX.png" alt="Schema" /></p>
  <p>In this case</p>
  <p><img src="https://i.stack.imgur.com/7lzY4.png" alt="Schema Names" /></p>
  <p>Or for below structure.</p>
  <pre><code>Sports2000
    ↳ PUB
       ↳ Tables
    ↳ SYSPROGRESS
       ↳ Tables
  </code></pre>