---
title: "What is the syntax to create partition function?"  
description: "What is the syntax to create partition function?"  
author: "Sumit Kesarwani"  
published: 2013-06-15  
updated: 2020-09-20  
canonical: https://www.mindstick.com/interview/1774/what-is-the-syntax-to-create-partition-function  
category: "mssql server"  
tags: ["mssql server"]  
reading_time: 1 minute  

---

# What is the syntax to create partition function?

CREATE PARTITION FUNCTION partition_function_name ( input_parameter_type )

AS RANGE [ LEFT | RIGHT ]

FOR VALUES ( [ boundary_value [ ,...n ] ] ) [ ; ]

## Answers

### Answer by Sumit Kesarwani

CREATE PARTITION FUNCTION partition_function_name ( input_parameter_type )

AS RANGE [ LEFT | RIGHT ]

FOR VALUES ( [ boundary_value [ ,...n ] ] ) [ ; ]


---

Original Source: https://www.mindstick.com/interview/1774/what-is-the-syntax-to-create-partition-function

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