# SCHEMATA

This view contains information about schemas (databases).

| Column Name                  | Description                                                 |
| ---------------------------- | ----------------------------------------------------------- |
| `CATALOG_NAME`               | The name of the related catalog for a given database.       |
| `SCHEMA_NAME`                | The name of a given database.                               |
| `DEFAULT_CHARACTER_SET_NAME` | The name of the default character set for a given database. |
| `DEFAULT_COLLATION_NAME`     | The name of the default collation for a given database.     |
| `SQL_PATH`                   | This value is always`NULL`.                                 |

***

Modified at: August 29, 2022

Source: [/db/v9.1/reference/information-schema-reference/cluster-component/schemata/](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/cluster-component/schemata/)

(An index of the documentation is available at /llms.txt)