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?