> ## Documentation Index
> Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt
> Use this file to discover all available pages before exploring further.

<AgentInstructions>

## Submitting Feedback

If you encounter incorrect, outdated, or confusing documentation on this page, submit feedback:

POST https://docs.firebolt.io/feedback

```json
{
  "path": "/reference-sql/information-schema/schemata",
  "feedback": "Description of the issue"
}
```

Only submit feedback when you have something specific and actionable to report.

</AgentInstructions>

> Use this reference to learn about the metadata available about schemas using the information schema.

# Schemata

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](/overview/security/rbac/database-permissions/schema-permissions#schema-level-privileges) or ownership of the schema object.

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
SELECT
  *
FROM
  information_schema.schemata;
```

## Columns in information\_schema.schemata

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

| Column Name                      | Data Type | Description                                                    |   |
| :------------------------------- | :-------- | :------------------------------------------------------------- | - |
| catalog\_name                    | TEXT      | Name of the catalog.                                           |   |
| schema\_name                     | TEXT      | Name of the schema.                                            |   |
| schema\_owner                    | TEXT      | Owner of the schema.                                           |   |
| default\_character\_set\_catalog | TEXT      | The catalog that contains the character set. Defaults to NULL. |   |
| default\_character\_set\_schema  | TEXT      | The schema that contains the character set. Defaults to NULL.  |   |
| default\_character\_set\_name    | TEXT      | Default character set of the schema. Defaults to `UTF-8`.      |   |
| sql\_path                        | TEXT      | SQL path of the schema.                                        |   |
| description                      | TEXT      | Description of the schema.                                     |   |