SQLite Forum

Doc enhancements for new release
Login
Ryan, I agree with your mathfunc pickups. However, on:

> ALTER TABLE DROP COLUMN (In the reasons it may fail):
Current: "The column appears in a table CHECK constraint. However, the column being deleted can be used in a column CHECK constraint because the column CHECK constraint is dropped together with the column itself."
Suggested: "The column appears in a table CHECK constraint. However, the drop is allowed if the only such CHECK constraint is declared within the column itself, since such a constraint is dropped along with the column."

I see no lack of clarity in the original. The original "However" clause could perhaps be parenthetical, or dropped altogether as redundant.  However, your "However" clause, ostensibly referring to "such CHECK constraint", is actually (or most obviously) referring to "a table CHECK constraint" and going on to say what may happen if **that** is declared within the column itself, (making it a column constraint rather than a table constraint.) For a qualifier that is not strictly necessary, that seems to be a distraction.

Care to propose a better qualifier?