SHOW ENUMS - CockroachDB

The SHOW ENUMS statement lists the in the current database.

Syntax

Parameters

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

Examples

The following example creates a .

> 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