07 · Tables A→ZD · Design the schema
Tune column settings
Toggle primary key, uniqueness, and nullability on existing columns - with validation.
update_column_settings toggles a column's is_primary_key, is_unique,
and is_nullable. Tightening a constraint validates existing data first;
loosening one is always safe.
Update
eddytor set column eddytor sales orders --column order_id --is-unique true
eddytor set column eddytor sales orders --column amount --is-nullable falseupdate_column_settings(table="eddytor.cfg_xxx.<uuid>_orders",
column="order_id", is_unique=true)To edit a column's description / tags (display metadata, not constraints), use
eddytor set field / the field-metadata tool.
Tightening validates first
Heads up
Enabling a PK or uniqueness validates existing data and is
rejected on failure.
is_nullable: false checks for existing NULLs and rejects
if any are found; uniqueness/PK rejects on duplicates. Fix the data
(merge_rows) and retry.Loosening - disabling uniqueness/PK, making a column nullable - is always safe.
After changing
get_table_schema to confirm, then
validate_constraints to ensure existing data still
passes.