Yes. You can use "pragma table_info(tablename)" to get information about a
table, the whole table, and nothing but the one table. Or you can use the
bunch-o-views which will give you a data dictionary to be able to get the same
data by treating all the various introspection pragma's as tables and letting
you query for specific information such as:
select affinity from SysColumns where ObjectType='table' and
or perhaps even
select ObjectType, ObjectName, from SysColumns where ColumnName =
One is simply more selective that the other. The pragma's use ill-conceived
field names (containing spaces and other kaiboshery) whereas the views rename
such ill-conception to something not quite so ill such that "escaping" is not
required (which is as God intended when she invented the concept of variable
naming and so forth).
The fact that there's a Highway to Hell but only a Stairway to Heaven says a
lot about anticipated traffic volume.
>From: sqlite-users [mailto:sqlite-users-
>boun...@mailinglists.sqlite.org] On Behalf Of Bart Smissaert
>Sent: Saturday, 6 January, 2018 15:00
>To: SQLite mailing list
>Subject: Re: [sqlite] sqlite3_column_decltype and max and min
>Not sure how this works.
>I had a look at your views.
>Are you saying that I should get the data type (only if
>sqlite3_column_decltype produces null) by querying these views,
>the column name?
>On Sat, Jan 6, 2018 at 7:27 PM, Keith Medcalf <kmedc...@dessus.com>
>> select max(integer_date) as [max_integer_date int_date] from table1
>> fetch the cursor.description and split the column name at the
>> right part is the datatype for your handy dandy use.
>> You may also be able to use the same method in the table
>> provided that the type carries through, but I do not remember
>> create table1([integer_date] [integer int_date])
>> The former is how pySqlite2 links adapters and converters to the
>> The fact that there's a Highway to Hell but only a Stairway to
>> a lot about anticipated traffic volume.
>> >-----Original Message-----
>> >From: sqlite-users [mailto:sqlite-users-
>> >boun...@mailinglists.sqlite.org] On Behalf Of Bart Smissaert
>> >Sent: Saturday, 6 January, 2018 10:45
>> >To: General Discussion of SQLite Database
>> >Subject: [sqlite] sqlite3_column_decltype and max and min
>> >Is there any way with sqlite3_column_decltype (or otherwise) to
>> >declared data type (as in the table create sql in SQLite_master)
>> >it is
>> >a simple expression such as max and min?
>> >for example we have a table created like this:
>> >create table1([integer_date] int_date)
>> >and we do:
>> >select max(integer_date) from table1
>> >I would then like to get returned int_date, rather than integer.
>> >The custom datatype int_date is needed for formatting purpose to
>> >app that receives
>> >the data that the column holds dates as integers.
>> >To do this in application code is not that simple, so I hope there
>> >simpler way.
>> >sqlite-users mailing list
>> sqlite-users mailing list
>sqlite-users mailing list
sqlite-users mailing list