Partition existing table on non-primary key field

135 Views Asked by At

I have an existing table "Case_details" with below columns:

  • Case_ref varchar (PK)
  • Case_name varchar
  • Status varchar
  • Archive_date Datetime

I want to partition this table based on _Archive_date_. I have created a partition function and partition scheme already. I just need to partition the above existing table! What are the steps to do it?

0

There are 0 best solutions below