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.