SHOW TYPES

On this page Carat arrow pointing down
Warning:
CockroachDB v22.2 is no longer supported as of June 5, 2024. For more details, refer to the Release Support Policy.

The SHOW TYPES statement lists the user-defined data types in the current database.

Note:

CockroachDB currently only supports enumerated user-defined types. As a result, SHOW ENUMS and SHOW TYPES return the same results.

Syntax

SHOW TYPES

Required privileges

The CONNECT privilege on the database is required to list any user-defined types in the database.

Examples

icon/buttons/copy
> CREATE TYPE weekday AS ENUM ('monday', 'tuesday', 'wednesday', 'thursday', 'friday');
icon/buttons/copy
> CREATE TYPE weekend AS ENUM ('sunday', 'saturday');
icon/buttons/copy
> SHOW TYPES;
  schema |  name   |                  value
---------+---------+-------------------------------------------
  public | weekday | monday|tuesday|wednesday|thursday|friday
  public | weekend | sunday|saturday
(2 rows)

See also


Yes No
On this page

Yes No