CODEWITHSUNDEEP
sql-serverazureazure-sql-database
Vinit Patel
Vinit Patel

Reputation: 2474

create Partition is not working in Azure Sql server

I am trying to Create Partition in my azure Sql server. my Sql server version is :- 11.0.9231 and my query is 

USE [dbName]
GO

-- Create the partition function
CREATE PARTITION FUNCTION PF_HASH_BY_VALUE (BIGINT) AS RANGE LEFT 
FOR VALUES (100000, 200000, 300000, 400000, 500000, 600000, 700000, 800000, 900000)
GO

Below is my error message:- 

Msg 40510, Level 16, State 1, Line 5
Statement 'CREATE PARTITION FUNCTION' is not supported in this version of SQL Server.

now on this bloq says it's working with sql server which are later from 2008. https://msdn.microsoft.com/en-us/library/ms187802.aspx

then why i got error message, can any one give me idea about it.

Regards, vinit Patel

Upvotes: 0

Views: 506

Answers (1)

Sumit Gupta
Sumit Gupta

Reputation: 2192

Azure SQL Server is not regular SQL Server. There are lots of queries that are not supported in Azure SQL. For example, Cross referencing different database within same Azure SQL server is not supported but was supported in regular SQL Server (or Express edition).

Also, I will advise to upgrade to v12 if it is compatible, as V12 has lot more query support and feature then v11 as you are running.

Upvotes: 2

Related Questions