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

Reply via email to