- 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"
-
-
Imagination is Innovation
db2 connect to <db_name>
db2 "select schemaname from syscat.schemata" OR
db2 "select distinct tabschema from syscat.tables"
You must be logged in to post a comment.