sventhan
asked on
Drop Partition | SQL Server 2008 R2 EE
Experts -
I've a table with Daily Partitions with few million rows. I would like to roll off the old partitions as the new one comes in (14 days window).
How do I drop the old partitions? I've created the partitions till year 2011. Currently my worry is to just write a script to drop the old partitions.
I've done oracle partitions and it seems SQL partitions looks complicated to me with partition functions and schemas.
Any help appreciated.
Thanks,
~Sve
I've a table with Daily Partitions with few million rows. I would like to roll off the old partitions as the new one comes in (14 days window).
How do I drop the old partitions? I've created the partitions till year 2011. Currently my worry is to just write a script to drop the old partitions.
I've done oracle partitions and it seems SQL partitions looks complicated to me with partition functions and schemas.
Any help appreciated.
Thanks,
~Sve
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks.
ASKER
In oracle I issue something like this to drop a single partition
ALTER TABLE tablename DROP PARTITION partition_name;
Is there anything equivalent for this in SQL server? Do I've to modify the partition function/Scheme to drop the partitions?