SQLite Forum

create taable with syntax error works ?
You still have a strangely spelled affinity for the 3rd and final column specification. With your change, it meets criterion 2.

I did not say the affinity was your problem. Your problem<sup>a</sup> is that, because of your strange spelling, you expect an error but SQLite does not see one.


a. This might be considered SQLite's problem, but it is a long-standing one. You may be interested in a soon-to-be-released SQLite feature, details of which can be seen <u>[here](https://www.sqlite.org/draft/stricttables.html)</u> and in this forum in threads with "strict" (or casing equivalents) in their title.