How to delete tables in sqlite database using wildcard search?

vb.net sqlite

The DROP TABLE statement works only with a single, fixed table name.

You can execute a query like this to get all table names you want:

SELECT nameFROM sqlite_masterWHERE type = 'table'  AND name LIKE '%FunctionAnalysis%'

Then your program has to construct and execute a DROP TABLE statement with each returned value.

CodeHunter