On 8 May 2018, at 5:37pm, Bart Smissaert <bart.smissa...@gmail.com> wrote:
>> SQLite does not have column types. It has column affinities instead. > > OK, so I would like to see that declared column affinity as that will > determine how to process the data. Ah. You don't care about the data, you want the column declaration. Okay. <https://sqlite.org/pragma.html#pragma_table_info> Do whatever you would do for a SELECT statement but instead of a SELECT statement execute PRAGMA schema.table_info(table-name) The problem is that you don't want that, either. Because you may be doing JOINs or calculations. Unfortunately SQLite does not derive affinities as it does a calculation, it just uses whatever values it finds. Sorry. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users