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