It is already there in section 3.1 plain for all the world to see. The answer is that by Rule 1 the affinity is INTEGER. ``` sqlite> create table xxx (a text b integer); sqlite> pragma table_info(xxx); ┌─────┬──────┬────────────────┬─────────┬──────┬─────────┬────────────┬────┬───────┬─────────┐ │ cid │ name │ type │ aff │ coll │ notnull │ dflt_value │ pk │ rowid │ autoinc │ ├─────┼──────┼────────────────┼─────────┼──────┼─────────┼────────────┼────┼───────┼─────────┤ │ 0 │ a │ text b integer │ INTEGER │ │ 0 │ │ 0 │ 0 │ 0 │ └─────┴──────┴────────────────┴─────────┴──────┴─────────┴────────────┴────┴───────┴─────────┘ ``` NB: This is my "improved" pragma that shows more information from the loaded schema, so regular release version SQLite3 will not return the additional information, although they will have the same internal schema information structures.