|
youngb912
Starting Member
USA
14 Posts |
 Posted - 06/17/2010 : 21:02:06
|
I need to partition an existing table as below. The table name is sales_log. Here is what I'm doing so far
CREATE PARTITION FUNCTION MyPartitionRange (Date)
AS RANGE LEFT FOR VALUES (1)
Partition 1 – Partition value <= 20 days
Partition 2 – Partition value > 20 days
CREATE PARTITION SCHEME MyPartitionScheme AS
PARTITION MyPartitionRange
ALL TO ([PRIMARY])
I copied the above from a site as my template. Now I want to partition an existing table (Saleslog) so that data less than 20days remain on partition1 and those older than 20 goes to partition two. How do I get this to work? |
|
Table partitioning
