Christian Schmitz wrote: > I would like to see more alter table things. Currently, ALTER TABLE implements only those changes that can be done without rewriting any of the table data.
> ALTER TABLE testTable SET DEFAULT FOR testField TO 0 Not all values in this column might actually be stored on disk. Changing the default value could change those rows. It is actually possible to do this, if you force all rows to be rewritten first, and then change the table definition: http://stackoverflow.com/questions/25911191/altering-a-sqlite-table-to-add-a-timestamp-column-with-default-value > ALTER TABLE testTable SET UNIQUE FOR testField TO 1 You can already do the same with an index. (Renaming that index to "sqlite_autoindex_testTable_n" and adjusting the table definition is left as an exercise.) Regards, Clemens
