SQLite Forum

About STRICT tables
Login
A column about strict tables has appeared in the draft site:

<https://www.sqlite.org/draft/stricttables.html>

Possibly a good idea to raise a discussion on it.  I'll open with a few things:

1) The syntax to mark a table as strict puts the word STRICT at the end of the CREATE line.  Is there a good reason why the word doesn't go after CREATE ?  I'm likely to 'lose' a word at the end of the line: my eyes could pass over it and not see it.
2) Could correct use of single and double quotes be enforced for the strict CREATE commands ?  Or is that better associated with the strict PRAGMA ?
3) Could the strict mode make all tables STRICT, whether declared STRICT or not ?

For reference, here's the page about strict mode:

<https://sqlite.org/src/wiki?name=StrictMode>