In #97372, a limitation was introduced that prevents a column from being dropped if it is referenced by a partial index predicate. To drop such a column, the partial indexes need to be dropped first. Ideally, we could lift this restriction.

I explored lifting this restriction in #97368, though I didn't iron out all the details. It'll be tricky to get all the edge-cases ironed out.

Jira issue: CRDB-24899