Repository navigation
Add check constraints at table-alter time #178
Description
Quoting the documentation.
SQLite3 supports specifying check constraints on the table or on the column definition. We currently only support adding a check constraint via a column definition, since the table definition approach only works at table-creation time and cannot be added at table-alter time.
Just wanted to let you know that as of SQLite 3.53.0 this is possible.
Enhance ALTER TABLE to permit adding and removing NOT NULL and CHECK constraints.
Activity
warmwaffles commentedon Apr 30, 2026
OOO I did not catch that in the release notes. I'll get support for that added soon.
louwers commentedon Apr 30, 2026
Yeah I am not even a user, but I thought you might want to know. :)
mochaaP commentedon Sep 30, 2026
Hi, I'm willing to work on this. Do you accept PRs?
mochaaP commentedon Sep 30, 2026
see mochaa/main for latest changes.
warmwaffles commentedon Sep 30, 2026
Yes 🤣 and if you have anything else you want to propose updating or changing, you are free to push.