New answers tagged enum
0
votes
Add ENum Attribute to existing table using Alter
Oracle Database 23ai added enumeration domains. These are a series of name/value pairs. Create this first, for example:
create domain truck_types as enum (
small = 'S', medium = 'M', large = 'L'
);
...
Top 50 recent answers are included
Related Tags
enum × 49postgresql × 22
mysql × 18
index × 6
database-design × 5
foreign-key × 4
constraint × 4
alter-table × 4
sql-server × 3
mariadb × 3
datatypes × 3
order-by × 3
array × 3
performance × 2
join × 2
mysql-8.0 × 2
oracle × 1
sql-server-2008 × 1
query-performance × 1
t-sql × 1
sql-server-2016 × 1
optimization × 1
trigger × 1
ssms × 1
partitioning × 1