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?