On 10 Feb 2012 at 07:55, bhaskarReddy <uni...@gmail.com> wrote: > PRAGMA table_info(yourtablename); will display colNumber, colName, colType, > .... > ex: 0|slotId|INTEGER|0||0 > 1|ponChannelId|INTEGER|0||0 > 2|onuType|INTEGER|0||0 > 3|onuSerialNumber|TEXT|0||0 > 4|onuId|INTEGER|0||0 > 5|plannedSwVersion|TEXT|0||0 > 6|adminStatus|INTEGER|0||0 > > In that how can we extract INTEGER.
I expect that in the result set, third column (index 2) says INTEGER. -- Cheers -- Tim
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users