SQLite Forum

First Create a database with:

CREATE TABLE test(
a INTEGER)


then execute the following c# code:

using System;
using System.Data.SQLite;

namespace SQLiteDataTypeTest
{
    class Program
    {
        static void Main(string[] args)
        {
            SQLiteConnection Connection = new SQLiteConnection(@"Data Source=<THE_DATABASE>;");
            Connection.Open();
            
            var sqlCommand = Connection.CreateCommand();
            var sqlQuery = "pragma table_info(test)";

            sqlCommand.CommandText = sqlQuery;

            var reader = sqlCommand.ExecuteReader();

            Console.WriteLine("Column name = " + reader.GetName(5)); //PK column
            Console.WriteLine("Datatype = " + reader.GetDataTypeName(5)); //PK column
            Console.ReadKey();
            reader.Close();
            Connection.Close();
        }
    }
}




This will result in the output:
Column name = pk
Datatype =


Datatype should here be integer since that's the column it's type.