Changing the member list of SQL ENUM columns is very expensive.^100%

Be the first who add reasons!

Cite code: 13

Created at: Aug. 24, 2022, 12:45 p.m.

Created by: whysage

You can't reuse the member-list of an SQL ENUM column in other tables.^100%
---
100%
Save
Rated by: whysage
Getting a list of distinct SQL ENUM members is a pain.^100%
---
100%
Save
Rated by: whysage
SQL ENUM columns may only offer limited or negligible effects on optimization.^100%
---
100%
Save
Rated by: whysage
SQL ENUM columns have noteable gotchas.^71%
---
71%
Save
Rated by: whysage
SQL ENUM data type is evil.^83%
---
83%
Save
Rated by: whysage
SQL ENUM data is not being treated like data.^100%
---
100%
Save
Rated by: whysage
SQL ENUM has limited portability to DBMS.^60%
---
60%
Save
Rated by: whysage
It's impossible to add additional attributes or related info to SQL ENUM.^100%
---
100%
Save
Rated by: whysage
Choose not to be around people who will sabotage you.^68%
---
68%
Save
Rated by: citebot
Choose to be around people who will support you.^52%
---
52%
Save
Rated by: citebot