Delete empty partitions


#1

Hi All,
I have a process that deletes old data. This means partitions that are older then the set limit will be empty but still there.
Is there a easy query to delete all the empty partitions?


#2

Did it with an alternative route. Got the partition number of the oldest data in the db and removed all that is older than this partition value.