schemata

The view information_schema.schemata contains all schemas in the database.

SELECT * FROM information_schema.schemata;
SELECT * FROM information_schema.schemata WHERE NOT is_system;
SELECT schema_name, schema_owner, default_character_set_name, is_system FROM information_schema.schemata;

information_schema.schemata

column nametyperemarks
catalog_nameVARCHARAlways NULL
schema_nameVARCHAR
schema_ownerVARCHAR
default_character_set_catalogVARCHARAlways NULL
default_character_set_schemaVARCHARAlways NULL
default_character_set_nameVARCHARAlways UTF-8
sql_pathVARCHARAlways NULL
schema_idINTEGERreference to sys.schemas.id
is_systemBOOLEAN
commentsVARCHAR

Note: The last 3 columns (schema_id, is_system and comments) are extensions to the view as defined by ISO standard. They provide useful information and simplify filtering and joins with system tables/views in sys schema when needed.