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 .
  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 comment

Your email address will not be published. Required fields are marked *

Categories