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

How to find all schema names in DB2?

  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

 

Leave a Reply

Categories

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 3 other subscribers

%d bloggers like this: