SQL Formatter Tutorial
The SQL Formatter formats SQL statements, verifies syntax, and color-codes variables, invalid field or table names, optimization forces and comments. The use of indenting and highlighting gives SQL statements a standard of formatting that is easy to read.
To format a SQL statement
-
Click
.
-
After entering a SQL statement in the left pane of the window, click
.
Comments, bind variables, optimizer forces, invalid column or table names, and variables are highlighted in different colors. If there is a syntax error, an error message from Adaptive Server displays.