# SHOW SCHEMAS
`SHOW SCHEMAS` returns a list of all schemas available in Materialize.

> For the complete documentation index, see [llms.txt](https://preview.materialize.com/materialize/40269/llms.txt).


`SHOW SCHEMAS` returns a list of all schemas available in Materialize.

## Syntax

```mzsql
SHOW SCHEMAS [ FROM <database_name> ];
```

Syntax element                | Description
------------------------------|------------
**FROM** <database_name>      | If specified, only show schemas from the specified database. Defaults to the current database. For available databases, see [`SHOW DATABASES`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/show-databases/index.md).

## Details

### Output format

`SHOW SCHEMAS`'s output is a table with one column, `name`.

## Examples

```mzsql
SHOW DATABASES;
```
```nofmt
   name
-----------
materialize
my_db
```
```mzsql
SHOW SCHEMAS FROM my_db
```
```nofmt
  name
--------
 public
```

## Related pages

- [`CREATE SCHEMA`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/create-schema/index.md)
- [`DROP SCHEMA`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/drop-schema/index.md)