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

# SHOW TYPES

The `SHOW TYPES` statement lists the user-defined [data types](https://docs.cockroachlabs.com/docs/v24.2/data-types) in the current database.

## Syntax

```
SHOW TYPES
```

## Required privileges

The `CONNECT` [privilege](https://docs.cockroachlabs.com/docs/v24.2/security-reference/authorization#managing-privileges) on the database is required to list any user-defined types in the database.

## Examples

The following example creates a [user-defined type](https://docs.cockroachlabs.com/docs/v24.2/create-type).

```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> CREATE TYPE weekday AS ENUM ('monday', 'tuesday', 'wednesday', 'thursday', 'friday');
```

```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> CREATE TYPE weekend AS ENUM ('sunday', 'saturday');
```

```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> SHOW TYPES;
```

```
  schema |  name   | owner
---------+---------+--------
  public | weekday | root
  public | weekend | root
(2 rows)
```

## See also

* [`ENUM`](https://docs.cockroachlabs.com/docs/v24.2/enum)
* [Data types](https://docs.cockroachlabs.com/docs/v24.2/data-types)
* [`CREATE TYPE`](https://docs.cockroachlabs.com/docs/v24.2/create-type)
* [`ALTER TYPE`](https://docs.cockroachlabs.com/docs/v24.2/alter-type)
* [`DROP TYPE`](https://docs.cockroachlabs.com/docs/v24.2/drop-type)