---
title: "What are the steps to partition a non partitioned or existing table?"  
description: "What are the steps to partition a non partitioned or existing table?"  
author: "Sumit Kesarwani"  
published: 2013-06-15  
updated: 2020-09-17  
canonical: https://www.mindstick.com/interview/1777/what-are-the-steps-to-partition-a-non-partitioned-or-existing-table  
category: "mssql server"  
tags: ["mssql server"]  
reading_time: 1 minute  

---

# What are the steps to partition a non partitioned or existing table?

**1-**Create a partition function.

**2-**Create a partition scheme.

**3-** Drop the existing clustered index.

**4-**Recreate the clustered index on the partition scheme.

## Answers

### Answer by Sumit Kesarwani

**1-**Create a partition function.

**2-**Create a partition scheme.

**3-** Drop the existing clustered index.

**4-**Recreate the clustered index on the partition scheme.


---

Original Source: https://www.mindstick.com/interview/1777/what-are-the-steps-to-partition-a-non-partitioned-or-existing-table

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.