sql - Drop table in old version of SQLite where IF EXISTS is not supported

Question

My version of SQLite does not support the IF EXISTS operator. How can I drop a table which may or may not exist without getting an error slapped at me?

I can't update the version on a live application right now, so I cannot use a SQLite version that supports IF EXISTS.

Answer 1

You can use:

DROP TABLE IF EXISTS TABLE_NAME;