Here is a good SQL Formatter onOnline: SQL-Format.org. It also has a bunch of examples of commonly used queries. It's mostly for SQL-Server, but should work fine for others as well.

Natively: SET SHOWPLAN_XML

###MySQL

Online: MySQL Syntax Check

Natively: EXPLAIN

###PostgreSQL & PL/pgSQL

Plugin: pg-validator

Natively: EXPLAIN

###SQLite

Plugin: sqllogictest

Natively: EXPLAIN

###Oracle:

Natively: EXPLAIN

###SQL

Here is a good SQL Formatter on SQL-Format.org. It also has a bunch of examples of commonly used queries. It's mostly for SQL-Server, but should work fine for others as well.

#SQL

General:

Program: Mimer SQL Validator

Online: FreeFormatter.com

###SQL Server / Transact-SQL

Online: SQL-Format.org

Natively: SET SHOWPLAN_XML

###MySQL

Online: MySQL Syntax Check

Natively: EXPLAIN

###PostgreSQL & PL/pgSQL

Plugin: pg-validator

Natively: EXPLAIN

###SQLite

Plugin: sqllogictest

Natively: EXPLAIN

###Oracle:

Natively: EXPLAIN

Source Link

answered May 1, 2015 at 15:46

Phrancis

20.5k
35
65

###SQL

Here is a good SQL Formatter on SQL-Format.org. It also has a bunch of examples of commonly used queries. It's mostly for SQL-Server, but should work fine for others as well.

Post Made Community Wiki by Phrancis

occurred May 1, 2015 at 15:46

Stack Exchange Network

Return to Answer

SQL

SQL Server / Transact-SQL

MySQL

PostgreSQL & PL/pgSQL

SQLite

Oracle:

SQL

SQL Server / Transact-SQL

MySQL

PostgreSQL & PL/pgSQL

SQLite

Oracle: