Redgate's SQL Prompt Core is only available inVisual Studio.

As an add-in, SQL Prompt Pro strips away the repetition of coding.

As well as autocompleting your code, SQL Prompt Pro takes care of other things, so you can concentrate on how the code actually works.

If you need to write, refactor, or explore database code, you can try it out for free for 28 days.

You can buy a perpetual license or an annual subscription for SQL Prompt to give you more flexibility.

I am a huge fan of Redgate's software, and I can confidently say that SQL Prompt is a masterpiece.I have been able to shorten my script time down to a quarter or less.The settings allow me to tailor the tool to my coding style.

It is helpful to make code reviews more efficient and to reduce long-term product maintenance costs by having every developer's code formatted the same way.

One of the reasons I'm such a fan of Redgate's products is that I like to work smarter, and one of my favorite tools is theSQL Prompt, an SSMS tool that adds missing features, or has similar features which work better.If you use SSMS, it will make your life better.

I love the prompt.The tool is easy to use and fast.The way it handles autocompletion makes it a great tool for improving speed and quality in our development efforts.It is loved by all of the development team.

It saves huge amounts of time, increases productivity, enforces common layout and coding standards, and means I can focus fully on the task in hand.

It's such a powerful programming aid that I use it whenever I write anySQL, simple or complex.I don't have to memorize or look up obscure object names anymore.

I specialize in back-end systems.About half of my day is spent in the studio.I am at least 30% more productive since I started using the Prompt.My clients are starting to notice.I don't understand how I was able to write Transact-SQL before this tool.

If you want to create and share your own styles, you can use the full format options in SQL Prompt Pro.You can get a 28-day free trial.

Work in your preferred style, then switch to your shared team style for co-working, and on to the company-wide style when you are ready to ship.

Our advanced options allow you to modify your styles to your liking, and you can even share them with your friends and colleagues.

By using our handy actions shortcut, you can either select a fragment of the script you want to format or disabling it for certain blocks.

Our smart code completion works as you type, providing suggestions to help make your coding fast and accurate.

To script out an object in a query, simply right click and choose the script object from the menu.

You can choose an object or synonym from the query window.

If you want to know if any objects are referencing other objects that have been dropped, use SQL Prompt to find invalid objects in your database.

You can access your data and see a summary of the actions that a script performs.

It's possible to split a table into two.If you want to improve database performance or change the database design, this is useful.

There are over 90 rules available from the Options menu.Code issues are highlighted with quick tips on hover and further details when you click on the lightbulb icon.

You can apply an auto- fix to bring your code up to standard if you select the orange lightbulb icon after the code analysis has highlighted problematic code.

The side panel gives you more information about the issue and how you can fix it.

Group code issues by type and export them if you want.It's much easier for a team to perform code reviews or analyse a legacy code base because of this.

You can choose which suggestions you see, save them in a shared drive or a source control folder, and share them with your team.

You can save, preview, and rename tabs with tab history.You can start coding again in seconds if you pick up work where you left off.

You can quickly and easily identify which environment you are working in by setting different colors for different groups, server and databases.

You can watch how Steve Jones and Grant Fritchey did with SQL Prompt Pro.