CODEWITHSUNDEEP
sqlsql-serverazure-sql-databasessms
PJ99
PJ99

Reputation: 49

Missing Add Index Arrow in SSMS

When adding an index on my old machine I would use the below option to bring up the dialog box:

enter image description here

But on my new machine it is missing the little black right arrows:

enter image description here

And bringing up the T SQL you can see on the right when you click "new index..."

I'm connected directly to Azure SQL and my table is as below:

enter image description here

Am I missing something obvious?

Upvotes: 1

Views: 97

Answers (1)

Alberto Morillo
Alberto Morillo

Reputation: 15698

You don't have those options available when you are connected to Azure SQL Database. They are only available when you are connected to SQL Server instances.

It is a limitation of Azure SQL Database the user experience with SSMS is not yet the same, when you choose to create a "New index" using SSMS (as you have shown on the images you have included on your question) then SSMS will create a T-SQL index template on the query window, and the same will happen to create some of the Azure SQL Database objects, including logins, roles, schemas and statistics.

However, when you create logins, roles, schemas and statistics with SSMS on a database attached to a SQL Server instance then SSMS gives you a GUI dialog to create them.

Upvotes: 1

Related Questions