On 11 Sep 2015, at 1:17am, Peter Aronson <pbaronson at att.net> wrote:

> I do not believe NOT NULL is a CHECK constraint, though you could use gender 
> TEXT CHECK(typeof(gender) <> 'null') is and would work much the same way, 
> though possibly with less efficiency.

Looking at

<https://www.sqlite.org/syntax/column-constraint.html>

maybe the 'constraints' that the documentation refers to are the ones 
specifically declared using CHECK in the table definition.  Perhaps NOT NULL 
and UNIQUE don't count.

Simon.

Reply via email to