SQLite Forum

How to find out whether a table is STRICT?
Login
The upcoming [STRICT tables](https://www.sqlite.org/draft/stricttables.html) have already been discussed in several threads. I think it is a useful feature. For example, when processing a SELECT from a STRICT table, the code does not necessarily need to check the column type in each row and be prepared for all eventualities. How do I know whether a table is STRICT? Well, by parsing the create statement in `sqlite_schema`, but it would be nice to have an easier method.

Obviously `sqlite_schema` could get another column to indicate whether a table is strict or not, but this may not be feasible or the best. BTW, an easy indicator whether a table is with or WITHOUT ROWID would also be nice.