SQLite Forum

Is `JSON` a valid `create table` type?
Login
E.g:

```
CREATE TABLE row_a (
row_a_id INTEGER PRIMARY KEY AUTOINCREMENT,
doc JSON NOT NULL,
);
```

- Why does SQLite seem to take any string as a valid create table type?

- Is `JSON` a valid type? Ive seen it in example snippets online.

- Is there any benefit to defining the column types as SQLite seems to accept anything? What if I used SOMEINVALIDTYPE for all of the types?