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
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to