sqlite-column-affinity-auditor

Paste CREATE TABLE DDL from any dialect. See the type affinity SQLite actually assigns each column, which literals silently change storage class on insert, whether a STRICT table would accept the declared type, and which columns are true rowid aliases.

Input

Any dialect. Comments and multiple statements are fine.

Each line is inserted as a text value. An empty line is a legitimate probe, the empty string.