On 8 Jan 2020, at 11:15am, R Smith <ryansmit...@gmail.com> wrote: > I find the keyword NOTNULL listed among known SQLite keywords - > no. 88 on this page: https://sqlite.org/lang_keywords.html > > But cannot find a single mention of it or place to use it in SQLite, nor get > any hit on the sqlite.org search except in reference to the above list. > > 1. What is it for? > > 2. Does it have/need any documentation?
You can use NOTNULL as a condition. It's the opposite of ISNULL. You see it usually as a constraint, to ensure that a field has a value. However, NOT NULL with a space works too, and that version seems to be more popular these days. CREATE TABLE company ( code TEXT NOT NULL, name TEXT NOT NULL) You're right. I don't think I see NOTNULL mentioned anywhere else in the SQLite documentation. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users