SQL Formatter
Online SQL Beautifier | Online SQL Formatter | Online SQL Analyzer
What is SQL Beautifier or SQL Formatter ?
SQL beautifier or SQL formatter is a tool used to clean, pretty and format the SQL code to make it easy to read. Beautifying SQL means add spaces and indentation to properly clean and format SQL code.
How SQL Formatter Works ?
Our SQL beautifier tool add spaces and indentation to properly clean and format SQL code.
What are the advantages of SQL Formatting ?
- Human readable.
- Code looks pretty.
- Formatted version gives better understanding of code.
SQL Formatter Example
Before :
SELECT ca.proj_id AS proj_id, ca.ca_name AS proj_name, ca.ca_date_start AS proj_start, ca.ca_date_end AS proj_end,(SELECT COUNT(*) FROM rotations r WHERE r.proj_id = proj_id AND r.r_status = 'R' GROUP BY r.proj_id) r_count, (SELECT count(*) FROM rotations r WHERE r.proj_id = proj_id AND r.channel_id = 24 ) r_rtb_count FROM projs ca, clients c, proj_auth caa WHERE ca.client_id = 12345 AND ca.client_id = c.client_id AND ca_type = 'zzz' AND c.agency_id = 0 AND ca.client_id = NVL( caa.client_id, ca.client_id ) AND proj_id = NVL( caa.proj_id, proj_id ) AND caa.contact_id = 7890
After :
SELECT ca.proj_id AS proj_id, ca.ca_name AS proj_name, ca.ca_date_start AS proj_start, ca.ca_date_end AS proj_end, (SELECT COUNT(*) FROM rotations r WHERE r.proj_id = proj_id AND r.r_status = 'R' GROUP BY r.proj_id) r_count, (SELECT count(*) FROM rotations r WHERE r.proj_id = proj_id AND r.channel_id = 24 ) r_rtb_count FROM projs ca, clients c, proj_auth caa WHERE ca.client_id = 12345 AND ca.client_id = c.client_id AND ca_type = 'zzz' AND c.agency_id = 0 AND ca.client_id = NVL( caa.client_id, ca.client_id ) AND proj_id = NVL( caa.proj_id, proj_id ) AND caa.contact_id = 7890
Code Minifiers / Beautifiers
- CSS Minify
- CSS Beautify
- JavaScript Minify
- JavaScript Beautify
- JSON Minify
- JSON Beautify
- SQL Minify
- SQL Beautify
- XML Minify
- XML Beautify