Yes, thank you. /Wei
Roger Andersson-2 wrote: > > On 03/09/12 19:39, Wei Song wrote: >> Hello, >> >> I'm developing an SQLite extension which uses a function to set data into >> a table. I'd like to know how to check if a table exists in a database? >> > It's hard to say what you need but maybe > select count(*) from sqlite_master where type='table' and > name='tablename'; > /Roger > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://old.nabble.com/Building-an-SQLite-Extension%3A-How-to-check-if-a-table-exists-in-the-database--tp33473784p33474051.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

