Jaxidian Jaxidian - 27 days ago 6
SQL Question

How can I get SSMS to provide Auto Completion for SQL Azure?

I'm trying to identify a SQL Server Management Studio option (when writing/running queries) that provides table/column auto-complete functionality in the query editor. Unfortunately, SSMS seems to stop giving you Intellisense when you're connected to a SQL Azure database. Is there any way to fix this?

Are there any options, hacks, plugins or anything else that can accomplish this?

Answer Source

New Release of SQL Server Management Studio V17.2 now support Intelliscence so no need to have any other tools for this.

Please note that this will only work in case of SQL Server Authentication, that means logged in using SA Instance.

https://connect.microsoft.com/SQLServer/feedback/details/3100677/ssms-2016-would-be-nice-to-have-intellisense-on-azure-sql-databases