Feature Request: DROP PARTITION

We are implementing several partitioned tables using a revolving partition scheme. In this design, data is loaded into specific partition (by day), the partition contains N elements and is static (similar to the sliding window example). We do not desire to archive information for most of the tables as it is aged out, but would rather just drop the partition (like Oracle does). This would really simplify the process automation, since currently I have to create a staging table on the filegroup to be aged out, switch the active partition to the staging table, then drop the staging table to remove the aged out data.

Thanks,

Carl



Answer this question

Feature Request: DROP PARTITION

  • Feature Request: DROP PARTITION