SQL Prompt is a plug-in that increases how fast you can work with SQL.

Code-completion for SQL Server
Automated SQL reformatting to match your preferred style
Rapid access to your database schema information
Snippets cut down repetitive typing

Code completion

As you type SQL Prompt provides unobtrusive support, suggesting appropriate keywords, tables, views, and other database objects. It even suggests complete join conditions based on foreign key constrains or matching column names. Where it makes sense SQL Prompt will complete entire statements for you, such as INSERT or ALTER VIEW.

SQL reformatting (Pro edition only)

The Format SQL command reformats any SQL to match your chosen coding style. Clear and accurate formatting make it much easier to understand complex SQL, and helps maintain a consistent style across your entire team.

Rapid access to schema information

Database documentation is displayed when you mouse over database objects and built in functions. You can also show the complete object definition and a summary of object columns or parameters.

Snippets

Insert common queries or short fragments of SQL with a few keystrokes. For example just type ssf to insert SELECT * FROM. SQL Prompt comes with an extensive set of built in snippets, and you can easily add new ones of your own.

Search

Use SQL Search to search your databases within SSMS. Find references to objects, navigate to objects, or find fragments of SQL text within stored procedures, functions, and views

Download Link :

Direct