SHOW ENUMS - CockroachDB

The SHOW ENUMS statement lists the enumerated data types in the current database.

Syntax

show_enums syntax diagram

Parameters

Parameter	Description
`name` `name.name`	The name of the schema from which to show enumerated data types, or the name of the database and the schema, separated by a “`.`”.

Examples

The following example creates a user-defined type.

> CREATE TYPE weekday AS ENUM ('monday', 'tuesday', 'wednesday', 'thursday', 'friday');

> CREATE TYPE weekend AS ENUM ('sunday', 'saturday');

> SHOW ENUMS;

  schema |  name   |                   values                   | owner
---------+---------+--------------------------------------------+--------
  public | weekday | {monday,tuesday,wednesday,thursday,friday} | demo
  public | weekend | {sunday,saturday}                          | demo
(2 rows)

> SHOW ENUMS FROM movr.public;

  schema |  name   |                   values                   | owner
---------+---------+--------------------------------------------+--------
  public | weekday | {monday,tuesday,wednesday,thursday,friday} | demo
  public | weekend | {sunday,saturday}                          | demo
(2 rows)

See also