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