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 comment

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

Categories