Search SQLite Documentation

Small. Fast. Reliable.
Choose any three.

Change log entries mentioning: ADD COLUMN

3.37.0	(2) When adding columns that contain a CHECK constraint or a generated column containing a NOT NULL constraint, the ALTER TABLE ADD COLUMN now checks new constraints against preexisting rows in the database and will only proceed if no constraints are violated.
3.31.0	(1) Add support for generated columns.
3.25.0	(2) Enhancements the ALTER TABLE command: Add support for renaming columns within a table using ALTER TABLE table RENAME COLUMN oldname TO newname. Fix table rename feature so that it also updates references to the renamed table in triggers and views.
3.24.0	(2) Add support for auxiliary columns in r-tree tables.
3.8.7.1	(2) Fix an assertion fault that can occur when updating the NULL value of a field at the end of a table that was added using ALTER TABLE ADD COLUMN.
3.4.1	(10) Add the capability of "hidden" columns in virtual tables.
3.3.3	(2) Authorizer callback now notified of ALTER TABLE ADD COLUMN commands
3.2.1	(1) Fix a memory allocation error in the new ADD COLUMN comment.
3.2.0	(1) Added support for ALTER TABLE ADD COLUMN.

You can also see the entire changelog as a single page if you wish.

Page generated by FTS5 in about 2.27 ms.