DROP TYPE

> CREATE TYPE IF NOT EXISTS status AS ENUM ('open', 'closed', 'inactive');

> SHOW ENUMS;

  schema |  name  |        value
---------+--------+-----------------------
  public | status | open|closed|inactive
(1 row)

> CREATE TABLE IF NOT EXISTS accounts (
        id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
        balance DECIMAL,
        status status
);

-- sqlchecker: ignore
> DROP TYPE status;

ERROR: cannot drop type "status" because other objects ([bank.public.accounts]) still depend on it
SQLSTATE: 2BP01

> DROP TABLE accounts;

> DROP TYPE status;

> SHOW ENUMS;

  schema | name | value
---------+------+--------
(0 rows)

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

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

> SHOW ENUMS;

  schema |  name   |                  value
---------+---------+-------------------------------------------
  public | weekday | monday|tuesday|wednesday|thursday|friday
  public | weekend | sunday|saturday
(2 rows)

> DROP TYPE weekday, weekend;

> SHOW ENUMS;

  schema | name | value
---------+------+--------
(0 rows)