Link Search Menu Expand Document

Information schema for databases

You can use the information_schema.databases view to return information about databases. You can use a SELECT query to return information about each database as shown in the example below.

SELECT
  *
FROM
  information_schema.databases;

Columns in information_schema.databases

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

Name Data Type Description
catalog_name STRING Name of the catalog. Firebolt provides a single ‘default’ catalog.
schema_name STRING Name of the database.
default_character_set_catalog NULL Not applicable for Firebolt.
default_character_set_schema NULL Not applicable for Firebolt.
default_character_set_name NULL Not applicable for Firebolt.
sql_path NULL Not applicable for Firebolt.