Is your feature request related to a problem? Please describe.

Currently, dropping a column that is referenced by an index (either directly or via STORING) will silently drop the index as well. Although this is described in the CockroachDB documentation, it is considered dangerous by a customer who runs a large on-prem microservice environment where they operate DBaaS for internal customers.

Describe the solution you'd like

Provide the ability not to drop the index on an opt-in basis (either via a cluster/session setting or CASCADE)

Describe alternatives you've considered

N/A

Jira issue: CRDB-11592

Epic CRDB-60817