how to get a of list schemas in specific database in DB2

Question

how to get a of list schemas in specific database in DB2. I am trying to get list of specific schemas in particular database

Answer 1

Try this:

select schemaname from syscat.schemata

The catalog view SYSCAT.SCHEMATA holds the schema information. Here is the overview of all DB2 LUW catalog views in case you need other information as well.