Format your own SQL code using this free online formatter. Try formatting your SQL code with a few pre-defined styles.
Powered by SQL Prompt
This SQL formatting tool is powered by SQL Prompt, which allows you to use, create, and share SQL styles directly in SSMS and Visual Studio. Find out more.
SELECT CompanyName,AddressType,AddressLine1 FROM Customer JOIN CustomerAddress ON (Customer.CustomerID=CustomerAddress.CustomerID) JOIN Address ON (CustomerAddress.AddressID=Address.AddressID) WHERE CompanyName='ACME Corporation'
or press Ctrl+Enter
“I have always been a huge fan of Redgate’s software, and I can confidently say that SQL Prompt is a masterpiece. It has super-enhanced my SQL scripting abilities and has cut my scripting time down to a quarter or less. The tool is very intuitive, and the comprehensive settings allow me to tailor it to my own coding style.”
“If you take SQL Prompt away from me, I'll have to quit!”
“The ability to have every DB developer’s code formatted the same way with the execution of a simple command is incredibly helpful to making code reviews more efficient, and to reducing long-term product maintenance costs.”
“Working smarter is one of the reasons I'm such a fanboy of Redgate's products…One of my favorite tools is SQL Prompt, an SSMS plugin that adds "missing" functionality, or has similar features which work better. Either way, if you use SSMS, SQL Prompt will make your life better.”
“I love SQL Prompt. The speed and friendly, intuitive nature of the tool is excellent. The way it handles autocompletion for eg CTEs and combinations of
APPLYand variables makes it a great tool for improving speed and quality for our development efforts. I've recommended it across the entire development team and it is loved by all.”
“It saves huge amounts of time, boosts productivity, enforces common layout and coding standards, and means I can focus fully on the task in hand, while letting the syntax and code take care of themselves.”
“I use SQL Prompt whenever I write any SQL, simple or complex, because it's such a powerful programming aid. I no longer have to constantly look up or memorize obscure object names and SQL commands – instead, I can just browse for them.”
“I am a consultant who specializes in backend systems. I normally spend about 50% of my day in SQL Server Management Studio. Since I started using SQL Prompt, I am at least 30% more productive. Even my clients are starting to notice. I honestly cannot comprehend how I managed to write Transact-SQL prior to this tool.”