The SQL Formatter checks the syntax of the SQL statement. The SQL statement is formatted only if the syntax is correct. The right pane [Formatted SQL] of the SQL Formatter window shows the formatted SQL statement. If the SQL statement has an invalid object, that object is highlighted in maroon (default color).
If you open the SQL Formatter with the SQL Optimizer as the active window, the SQL statement from the SQL Optimizer window is automatically copied to the SQL Formatter window. Otherwise, enter a SQL statement into the left pane of the SQL Formatter window.
To format a SQL statement
Click .
Enter the SQL text.
Click to format the SQL statement.
To help in the construction of SQL statements
Use these functions:
To terminate the format process
Click .
Note: The SQL Format supports only a single SELECT, SELECT INTO, DELETE, UPDATE, and INSERT SQL statement.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Nutzungsbedingungen Datenschutz Cookie Preference Center