'DROP COLUMN IF EXISTS in SQLite?

Using SQLite 3.37.2. The following queries work:

DROP TABLE IF EXISTS MyTable;
CREATE TABLE IF NOT EXISTS...;

But a similar query on a column generates an error:

ALTER TABLE MyTable DROP COLUMN IF EXISTS MyField;

Remove IF EXISTS and the query works fine.

Does SQLite support IF EXISTS and IF NOT EXISTS for adding/dropping columns? This related question appears to answer "no", though that was back in 2010. Perhaps something has changed in the latest version(s).



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source