SQL Prompt 5.2

SQL Server developers and DBAs use SQL Prompt to:

• Write SQL smoothly, with code-completion and SQL snippets
• Check database structure at a glance, viewing column dependencies 'in query'
• Keep databases tidy by finding invalid objects automatically
• Work with current and older databases, thanks to backwards compatibility

Do this and more with SQL Prompt Pro:

• Reformat SQL to a preferred style
• Summarize scripts
• Decrypt encrypted objects
• Smart rename to change the name any time an object appears in the database

For more information on the differences between Pro and Standard see the features page.

Screenshots: using SQL Prompt Videos: an introduction and tutorial to SQL Prompt 5

SQL Prompt is crammed with features that take the routine out of working with SQL, and leave you to focus on the tricky bits.

When you're writing code, SQL Prompt suggests appropriate keywords and objects for queries. It can even complete INSERT, ALTER and JOIN statements. To cut down on repetitive typing, SQL Prompt has an extensive, customizable set of snippets.

To avoid complications when editing your SQL, you can use smart renaming, view column dependencies straight from the query editor, and uncover invalid objects at a stroke.

Reformatting and script summaries make even the most garbled queries readable in a few clicks. SQL Prompt is also backwards compatible, so it can tackle older databases too.

Whether you need to write, edit, or explore database code, SQL Prompt makes everything effortless.

What people say...

Since I started using SQL Prompt, I am at least 30% more productive. I honestly cannot comprehend how I managed to write T-SQL prior to this tool.

John Ek, ekDEVELOPMENT

The scripts were much quicker to write, formatting was excellent and the quality was greatly improved as well. The quality was improved because I had the extra time to add those things we know we should but often neglect.

Lynton Mack, Micromine

Read more testimonials