Displays the names of specified schemas. If you do not specify an
alias as part of a schema name, SQL displays schema information
for all the attached databases. For each database that is not
multischema, SQL displays the message, "No schemas found". For
each multischema database, SQL displays the alias, followed by a
list of schemas contained in that database. Each schema name in
the list is preceded by the catalog and alias names.