SQL ADD alter table drop partition

[drewdeally]

Few Customer requests for a drop partition feature comparable to postgreSQL / EDB

https://www.enterprisedb.com/edb-docs/d/edb-postgres-advanced-server/user-guides/database-compatibility-for-oracle-developers-guide/9.5/Database_Compatibility_for_Oracle_Developers_Guide.1.338.html

this was allow customers who choose a range partition by date, the ability to remove data with a single command instead of staggered deletes.

In addition, for archival purposes detach and attach would be great for moving partitions across table which would allow customer to leverage Archival Partitioning to move relocate data across storage tiers.

Jira issue: CRDB-4063

[blathers-crl]

Hi @drewdeally, I've guessed the C-ategory of your issue and suitably labeled it. Please re-label if inaccurate.

While you're here, please consider adding an A- label to help keep our repository tidy.

_{🦉 Hoot! I am a Blathers, a bot for CockroachDB. My owner is otan.}