# SHOW CREATE TYPE
`SHOW CREATE TYPE` returns the DDL statement used to create the custom type.

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


`SHOW CREATE TYPE` returns the DDL statement used to create the custom type.

## Syntax

```sql
SHOW [REDACTED] CREATE TYPE <type_name>;
```


| Syntax element | Description |
| --- | --- |
| <strong>REDACTED</strong> | If specified, literals will be redacted. |


For available type names, see [`SHOW TYPES`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/show-types/index.md).

## Examples

```sql
SHOW CREATE TYPE point;

```

```nofmt
    name                    |    create_sql
----------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 materialize.public.point   | CREATE TYPE materialize.public.point AS (x pg_catalog.int4, y pg_catalog.int4);
```

## Privileges

- `USAGE` privileges on the schema containing the type.

## Related pages

- [`SHOW TYPES`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/show-types/index.md)
- [`CREATE TYPE`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/create-type/index.md)