Home » SAP » Basis » How to find all schema names in DB2?

How to find all schema names in DB2?

By in Basis, Database, db2, SAP on .
The short URL of the present article is: https://ipraby.com/ld7r
  1. How to find all schema names in DB2? 
    • db2 connect to <db_name>
    • db2 "select schemaname from syscat.schemata" OR
    • db2 "select distinct tabschema from syscat.tables"
    • schemalist

 

The short URL of the present article is: https://ipraby.com/ld7r

Leave a Reply

Continue with Facebook
Continue with Google
Continue with Twitter
Continue with Microsoft
%d