Yes, indeed works. Great, thank you! Marek
On Tue, Sep 10, 2019 at 9:13 AM Richard Hipp <d...@sqlite.org> wrote: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users