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

Reply via email to