On Tue, 31 Jan 2012 10:34:20 +0000, Bart Smissaert <[email protected]> wrote:
>http://www.sqlite.org/faq.html#q7 > >RBS And this: PRAGMA table_info(sometablename); -- returns metadata in a result set A few coding samples: http://icculus.org/~chunky/stuff/sqlite3_example/sqlite3_example_bind.c http://www.sqlite.org/cvstrac/wiki?p=SimpleCode >On 1/31/12, bhaskarReddy <[email protected]> wrote: >> >> Hi Friends, >> >> Is there any way to find the number of columns and column >> types in a table. >> >> I tried with "select count(*) from tablename". But it is >> showing number of records. >> >> Regards, >> Bhaskar. >> -- >> View this message in context: >> http://old.nabble.com/How-to-find-number-of-columns-and-types-in-a-table.-tp33235184p33235184.html >> Sent from the SQLite mailing list archive at Nabble.com. >> >> _______________________________________________ >> 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 -- Regards, Kees Nuyt _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
