SQLite Forum

Removing not null constraint doesn't behave correctly
I'm afraid the 12-step procedure isn't even enough.

Step#3: SELECT type, sql FROM sqlite_master WHERE tbl_name='X'

That doesn't include triggers associated with other tables, where SQL statements involving table X can be present.  I have several such use cases and I bet I'm far from alone.