On 9/10/19, Marek Wieckowski <[email protected]> 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
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
