> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-schemata-table.md).

# Information Schema SCHEMATA Table

The Information Schema SCHEMATA table stores information about databases on the server, including default character sets and collations.

The [Information Schema](/docs/server/reference/system-tables/information-schema.md) `SCHEMATA` table stores information about databases on the server.

It contains the following columns:

| Column                        | Description                                                                                                      |
| ----------------------------- | ---------------------------------------------------------------------------------------------------------------- |
| CATALOG\_NAME                 | Always def.                                                                                                      |
| SCHEMA\_NAME                  | Database name.                                                                                                   |
| DEFAULT\_CHARACTER\_SET\_NAME | Default [character set](/docs/server/reference/data-types/string-data-types/character-sets.md) for the database. |
| DEFAULT\_COLLATION\_NAME      | Default [collation](/docs/server/reference/data-types/string-data-types/character-sets.md).                      |
| SQL\_PATH                     | Always NULL.                                                                                                     |
| SCHEMA\_COMMENT               | Database comment.                                                                                                |

## Example

```sql
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA\G
...
*************************** 2. row ***************************
              CATALOG_NAME: def
               SCHEMA_NAME: presentations
DEFAULT_CHARACTER_SET_NAME: latin1
    DEFAULT_COLLATION_NAME: latin1_swedish_ci
                  SQL_PATH: NULL
            SCHEMA_COMMENT: Presentations for conferences
...
```

## See Also

* [CREATE DATABASE](/docs/server/reference/sql-statements/data-definition/create/create-database.md)
* [ALTER DATABASE](/docs/server/reference/sql-statements/data-definition/alter/alter-database.md)
* [DROP DATABASE](/docs/server/reference/sql-statements/data-definition/drop/drop-database.md)
* [SHOW CREATE DATABASE](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-database.md)
* [SHOW DATABASES](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-databases.md)
* [Character Sets and Collations](/docs/server/reference/data-types/string-data-types/character-sets/supported-character-sets-and-collations.md)

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}