[sqlite] Get fields type

[Simon Slavin]

On 13 Apr 2016, at 2:40pm, hfiandor <hfiandor at ceniai.inf.cu> wrote:

> I?m trying to do an application for coping from Excel table to SQLite table. 
> I have already identified both tables has the same field?s names and the 
> order. But not yet I have obtained the field?s types in the SQLite table.

You can use 'typeof()' for any value:

CREATE TABLE myTable (a INTEGER, b REAL);
SELECT a, b FROM myTable;
SELECT typeof(a), typeof(b) FROM myTable;
SELECT a, typeof(a), b, typeof(b) FROM myTable;

Simon.