SQLite Forum

How to find out whether a table is STRICT?
Awesome, I've been using an ugly hack to filter out shadow tables during db introspection: `SELECT * FROM sqlite_schema WHERE type = 'table' AND sql NOT LIKE 'CREATE TABLE ''%'` (since I noticed all FTS5 shadow tables started with single quotes). With this pragma_table_list I can join on the tables that are actually user-created tables.