SQL
Enum Removal
Enum types are stored in the catalog, and a catalog dependency is added to each table that uses them. It is possible to drop an enum from the catalog using the following command:  
```sql
DROP TYPE ⟨enum_name⟩;
```  
Currently, it is possible to drop enums that are used in tables without affecting the tables.  
> **Warning.  ** This behavior of the enum removal feature is subject to change. In future releases, it is expected that any dependent columns must be removed before dropping the enum, or the enum must be dropped with the additional `CASCADE` parameter.