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. |