Alex Rivera | Logout

Intellisense for JOINs in SQL Server Management Studio

Asked 2012-09-30T11:05:23.147
9

In SQL Server Management Studio (SSMS) is there an option to enable intellisense auto-completion for JOINs?

For example, if I type: 

SELECT * FROM Employee INNER JOIN _

at this point I would like intellisense to give me the tables related to Employee, and when I pick one to fill in the appropriate join condition, based on the foreign key relationships.

LinqPad does this for LINQ queries, which is great. I would like the same in SSMS. I am using SqlServer 2012.

sql-server intellisense ssms sql-server-2012
Edit
Report

1 Answer

2

I use devart's SQL Complete. As of this writing, it is half the price of Red Gate's SQL Prompt and has a similar feature-set. They have demo of their auto JOIN completion here: http://www.devart.com/dbforge/sql/sqlcomplete/images/join-clause-auto-generation.gif .

They offer a free version that is slightly better than SSMS 2008's Intellisense, but it does not include the auto JOIN suggestions of their paid versions.

Unfortunately, I have yet to run across a free tool offering what you seek.

answered 2012-10-31T13:48:48.647

Your Answer