SQL Prompt ^®

Code completion

SQL Prompt provides comprehensive code completion, with support for all non-CLR SQL syntax, and automatically suggests appropriate join conditions.

Instant access to schema information

See the schema details for objects in the suggestion list, and hover over objects in your script to see their schema definition and documentation.

Wildcard expansion and column picker

Expand SELECT * to a complete list of columns with a single keypress, or use the column picker to quickly insert the list of columns you need.

SQL snippets

Create snippets to insert fragments of SQL you use regularly. For example instead of typing SELECT * FROM with SQL Prompt you can just type ssf

Statement expansion

SQL Prompt automatically completes INSERT statements with a list of column names and values, ALTER PROCEDURE statements with the procedure definition, and more.

Search

SQL Search provides search within SSMS. Search your database objects, find object references, or find fragments of SQL text with just a few mouse clicks.

SQL formatting

Automatically fix the formatting of any SQL code you have to maintain. Formatting rules are configurable to match your preferred coding style.

On-the-fly schema decryption

For databases where you have permission, SQL Prompt locally decrypts encrypted views and stored procedures and shows you their definitions.

Price