Problem
Neither has a field in the structure editor. Both appear in the DDL tab only, so adding, changing or dropping one means writing the DDL by hand, and a multi-column check is invisible in the grid. Schema editing splits into two flows for a reason the user cannot see.
Proposed solution
- A Constraints section listing check constraints with name, expression and the columns involved, editable and stageable the way indexes and foreign keys already are.
- Generated column support on the column row: a toggle, an expression, and STORED or VIRTUAL where the engine offers both.
- Both stage into the pending queue, so Preview SQL (
Cmd+Shift+P) and Save Changes cover them.
- Hide the section on engines with no check constraint support rather than showing an empty one.
Alternatives considered
Write the DDL by hand in a query tab.
Related database type
PostgreSQL
Problem
Neither has a field in the structure editor. Both appear in the DDL tab only, so adding, changing or dropping one means writing the DDL by hand, and a multi-column check is invisible in the grid. Schema editing splits into two flows for a reason the user cannot see.
Proposed solution
Cmd+Shift+P) and Save Changes cover them.Alternatives considered
Write the DDL by hand in a query tab.
Related database type
PostgreSQL