Poor SQL is a free online tool to format T-SQL code and convert it into a nicely written code. It’s a simple and easy to use application that takes your T-SQL source code as input and applies advanced formatting options on it to make it look more organized. Poor SQL is kind of a beautification tool for T-SQL code, however, it also offers minifying or obfuscating the source code into smaller fragments.
T-SQL stands for Transact-SQL, a proprietary extension for SQL, used by Microsoft and Sybase in SQL Server. It expands the concept of Structured Query Language (SQL) and adds several features to it, including error and exception handling, transaction control, variable declaration, and row processing.
Applications which need to communicate with SQL Server uses T-SQL for talking to the database. So if you are developing such applications, you might find it useful to try some tool that can format the long T-SQL code for you. Here is this free online tool known as Poor SQL, which solves your T-SQL formatting problems. Let’s see how.
Format T-SQL code Online with Poor SQL:
Poor SQL is extremely easy to use. All you need to do is to go to the homepage of the service using the link given at the end of this article, paste your T-SQL code in the “Input SQL” tab, set the formatting options from the right panel, and hit the “Formatted SQL” tab.
Poor SQL applies the desired formatting options on your mangled code and quickly generates the formatted code. Apart from that, it also generates an HTML code for the source T-SQL code that you provide, that too for free!
Poor SQL provides various formatting options to properly structure your T-SQL code. These include colorizing the code, applying indentation, tab-spacing, and character-spacing, expanding comma list by trailing or space after commas, expanding Boolean expressions, CASE expressions, and BETWEEN conditions, changing case of keywords, and enabling keyword standardization.
Apart form that, it also provide some code minification/obfuscating options that formats your T-SQL source code by randomizing colors, line lengths, keyword case, preserving comments, and keyword substitution.
Key Features of Poor SQL:
- Free online tool to format T-SQL.
- Quickly beautify/ minify/ obfuscate T-SQL code.
- Provides various formatting options to choose from.
- Also generates HTML code for the source T-SQL code.
- Simple and easy-to-use.
- Available in English, French, and Spanish.
- Also available as SSMS/Visual Studio plugin, WinMerge plugin, and command-line tool.
The Final Verdict:
Poor SQL is a nice free tool to format T-SQL code online. It’s a simple and handy application that caters all your T-SQL code beautification and minification needs. Check out Poor SQL now and give it a try.