On 9/10/19, Marek Wieckowski <wiec...@gmail.com> wrote:
>
> Is there a way in sqlite to ensure (on the database side) that all inserts
> for such a table have to have explicit values for such a column?
Make it a WITHOUT ROWID table:
CREATE TABLE example_table (
id INTEGER PRIMARY KEY,
description TEXT NOT NULL
) WITHOUT ROWID;
--
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
