mardi 20 janvier 2015

How to delete tables in sqlite database using wildcard search?

I am using a sqlite database in my vb.net application. I want to delete tables from my database using wildcard search. For that I have use following command



DROP TABLE LIKE '%FunctionAnalysis%';


but this gives me error as



[10:17:56] Error while executing SQL query: near "'%FunctionAnalysis%'": syntax error


There might be some error in the syntax as I am new to SQLite and SQL queries. Please help.


Aucun commentaire:

Enregistrer un commentaire