SQL Beautifier & Formatter

SQL string formats with default indentation and out for SQL beautify . Online SQL formatter will be removed unwanterd space and displaying clean SQL code. Now deafult indentation rules added and align SQL code normally.

SQL Input

Our SQL Formatter helps you get prefect alignment and it doesn't allow random space or important content. Our formatter also helps you validate your Code without any error.

Why we are Using SQL Formatter?

  • Formats any SQL queries
  • It formats your queries even the statement is invalid
  • Formatter removes comments in the SQL
  • Beautify your statements
  • It suports MySQL,Microsoft SQL and other kind of databases

    SQL:

  • SQL-Structured Query Language
  • SQL is an relational database management system(RDBMS)
  • Through SQL you can manipulate your database
  • You can INSERT,UPDATE,DELETE & Modify your database

Examples

Minified SQL below :
CREATE TABLE emp ( empno INT PRIMARY KEY, ename VARCHAR(10), job VARCHAR(9), hiredate DATETIME, sal NUMERIC(7, 2), comm NUMERIC(7, 2) NULL, dept INT ) begin insert into emp values ( 1, 'JOHNSON', 'ADMIN', 6, '12-17-1990', 18000, NULL, 4 ) insert into emp values ( 2, 'HARDING', 'MANAGER', 9, '02-02-1998', 52000, 300, 3 ) CREATE TABLE dept ( deptno INT NOT NULL, dname VARCHAR(14), loc VARCHAR(13) ) begin insert into dept values (1, 'ACCOUNTING', 'ST LOUIS') insert into dept values (2, 'RESEARCH', 'NEW YORK') end                   
                        
Beautified SQL below :
CREATE TABLE emp (
empno INT PRIMARY KEY,
ename VARCHAR(10),
job VARCHAR(9),
hiredate DATETIME,
sal NUMERIC(7,2),
comm NUMERIC(7,2) NULL,
dept INT)
begin
insert into emp values
    (1,'JOHNSON','ADMIN',6,'12-17-1990',18000,NULL,4)
insert into emp values
    (2,'HARDING','MANAGER',9,'02-02-1998',52000,300,3)
CREATE TABLE dept (
deptno INT NOT NULL,
dname VARCHAR(14),
loc VARCHAR(13))
begin
insert into dept values (1,'ACCOUNTING','ST LOUIS')
insert into dept values (2,'RESEARCH','NEW YORK')
end