SSMS 2016 Would be nice to have IntelliSense on Azure SQL Databases - by Renken

Status : 


Sign in
to vote
ID 3100677 Comments
Status Active Workarounds
Type Suggestion Repros 1
Opened 8/30/2016 4:03:27 PM
Access Restriction Public


Would be nice to have IntelliSense on Azure SQL Databases.  Seems like all the data is there for columns, tables, and everything else in the schema.  Just nice to have when working on a large table or something to have a auto list of all the columns.
Sign in to post a comment.
Posted by Jane2006 on 10/19/2017 at 10:33 AM
One of my users notice this issue as well. After doing some research, it seems the issue is related to master database access. If the user is a member of AD Admin group on Azure, IntelliSense will work for him. If he is not a member of AD Admin group, even if he is set to be a db owner of the user database, IntelliSense still will not work.
Posted by SFEnander on 8/18/2017 at 5:57 AM
Subash.S That's wrong. It do work with "Azure Direcotry - Password" I hade problem first. Turned out my version of 17.2 was not the last one. After installing THE last version intellisense works like a charm (finally).
Posted by Subash.S on 8/8/2017 at 3:18 AM
SSMS 17.2 now support Azure SQL Database Intellisense. However Intellisense works only with SQL Server authentication and not with Active Directory authentications.
Posted by TadhgTycen on 12/12/2016 at 7:29 PM
I too would like to see IntelliSense in Azure SQL Databases.
Posted by Renken on 12/6/2016 at 2:29 PM
It is funny the MSSQL plugin for VS Code has IntelliSense for Azure databases.
Posted by Ian Lee - EAHCS on 12/6/2016 at 2:25 PM
+1 to this! I can't think of a feature more lacking in SSMS.