There's an argument for not having STRICT TABLEs at all. Just have a LAX keyword, or whatever a better word would be. To make the whole database STRICT use the PRAGMA. If you have some legacy table data you can't get rid of which violates STRICT ,declare the table as LAX before you use the PRAGMA. This automatically makes appropriate indexes and views LAX too.