# SHOW TYPES
`SHOW TYPES` returns a list of the data types in Materialize.

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


`SHOW TYPES` returns a list of the data types in Materialize. Only custom types
are returned.

## Syntax

```mzsql
SHOW TYPES [FROM <schema_name>];
```

Syntax element                | Description
------------------------------|------------
**FROM** <schema_name>        | If specified, only show types from the specified schema. Defaults to first resolvable schema in the search path. For available schemas, see [`SHOW SCHEMAS`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/show-schemas/index.md).

## Examples

### Show custom data types

```mzsql
SHOW TYPES;
```
```
   name
-----------
 int4_list
```

## Related pages

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