You can use the information_schema.schemata view to return information about schemas available in the database. Run a SELECT query to return information about each schema as shown in the example below.

To view schema information, you must have schema privilege or ownership of the schema object.

SELECT
  *
FROM
  information_schema.schemata;

Columns in information_schema.schemata

Each row has the following columns with information about the schema.

Column NameData TypeDescription
catalog_nameTEXTName of the catalog.
schema_nameTEXTName of the schema.
schema_ownerTEXTOwner of the schema.
default_character_set_catalogTEXTThe catalog that contains the character set. Defaults to NULL.
default_character_set_schemaTEXTThe schema that contains the character set. Defaults to NULL.
default_character_set_nameTEXTDefault character set of the schema. Defaults to UTF-8.
sql_pathTEXTSQL path of the schema.
descriptionTEXTDescription of the schema.