Well, to begin with, SQLite doesn't exactly have column data types like most other DBMS, rather, columns have affinities, which might be looked at as sort of preferences. See http://www.sqlite.org/different.html#typing and http://www.sqlite.org/datatype3.html#affinity
However, this command (http://www.sqlite.org/pragma.html#pragma_table_info) will list the "type" with which the column was declared: Pragma table_info (<table_name>); it just may not mean what you think it might. Best regards, Peter > -----Original Message----- > From: [email protected] [mailto:sqlite-users- > [email protected]] On Behalf Of Tarun > Sent: Tuesday, January 17, 2012 8:51 PM > To: [email protected] > Subject: [sqlite] How to get column datatype > > Hi All, > > Does SQLite support any SQL command to get column datatype of table > like varchar, INTEGER? > > Please share example of such command. It would be helpful for me. > > Thanking you. > > -- > Regards, > - Tarun Thakur > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
