ALTER clause

The ALTER clause is used to change existing definitions of enums.

1. Altering an enums

1.1 Adding an extra value

Use the following query to add a single value to an existing enum.

ALTER ENUM Suit ADD VALUE Joker;

1.2 Updating a value

Use the following query to change representation of an existing value in an existing enum.

ALTER ENUM Suit UPDATE VALUE Joker TO Wild;