CODEWITHSUNDEEP
sqlazure-sql-database
user3846899
user3846899

Reputation: 23

How come I have no option to Create Partition?

I have no option to Create Partition on my table.

I thought maybe I had to create a filegroup first, but I have no option for that either under the database properties.

What am I missing?

*This is an Azure database.

enter image description here

Upvotes: 0

Views: 512

Answers (1)

Leon Yue
Leon Yue

Reputation: 16431

We can create partition on table with T-sql like comments mentioned.

As you know, SSMS UI: Create Partition works well with local SQL Server, no option for Azure SQL Database.

Actually, not only the Create Partition option, there many options not support for Azure SQL database. Most documents only say the feature is supported in Azure SQL database with no details.

You could reference this blog:No UI dialogs in MS Azure / SQL Server Management Studio.

The reason is that SSMS do not have the full SSMS Support for Azure SQL database.

A lot of people complained about this in the SQL database feedback:

How can we improve Azure SQL Database?Full Management Studio Support

Such as:

  • "Graham Plowman commented · January 23, 2019 17:01

    The regular version of SSMS has a UI around all the security and user management options (and many others), making them a breeze to use.

    When SSMS is connected to a SQL Azure database, all this UI functionality is gone, replaced by bombing out to screens where one has to type in SQL commands!!

    Whatever next ? This was how we used to manage SQL server way back in the 1990's with version 4.3 before SSMS became a serious tool!!

    Kindly add the UI so it is the same as regular SQL installations. Bombing out to SQL is a highly backward step."

There is still no solution for now.

Hope this helps.

Upvotes: 1

Related Questions