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.