Marek Wieckowski, on Tuesday, September 10, 2019 08:08 AM, wrote... > > Yes, indeed works. Great, thank you! > > Marek > > > On Tue, Sep 10, 2019 at 9:13 AM Richard Hipp, on > > > On 9/10/19, Marek Wieckowski, on > > > > > > 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;
Will someone point me to a spot where I can understand this piece of SQL? Or, a simple explanation would do. Thanks. josé _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users