On 8 Jan 2020, at 11:15am, R Smith <[email protected]> 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
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
