Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Autocomplete on SQL Management Studio?

Tags:

Does anyone know if there's an add-in that does autocomplete for queries on SQL Management Studio?

like image 234
Rismo Avatar asked Oct 28 '08 21:10

Rismo


People also ask

How do I get suggestions in SQL?

From the SQL Prompt menu, click Options. Go to the Suggestions > Types of suggestion page. Select List all database columns after a SELECT statement.

How do I enable SQL IntelliSense?

On the Tools menu, click Options. Expand Text Editor, expand Transact-SQL, and then click IntelliSense.

How do I refresh IntelliSense in SQL Management Studio?

Select the Edit menu, select IntelliSense, then select Refresh Local Cache. Use the CTRL+Shift+R keyboard shortcut.

How do I disable IntelliSense in SQL Management Studio?

Open SSMS – Click on Tools, Options, Expand Text Editor, Transact – SQL, and then uncheck the box next to Intellisense. That's it. We are done.


2 Answers

You can also try Devart's free SQL Complete.

http://www.devart.com/dbforge/sql/sqlcomplete/

like image 108
Sergii Avatar answered Sep 21 '22 11:09

Sergii


Take a look at Red Gate's SQL Prompt.

like image 44
Michael DeLorenzo Avatar answered Sep 21 '22 11:09

Michael DeLorenzo