We have an existing table w/ monthly partitions of data. The partitions are added, it appears, yearly, via {insert process here we're still researching}. Trouble came when {X} forgot to add the '22 partitions into the lower environment.

Is it possible to modify the existing table setup & switch it over to INTERVAL (auto generation of newer partitions as needed)? Or would we need to re-setup: archive, create new, copy data...

Thanks in advance.