SQL Pretty Printer format options Reference
Index

Available format options for Where clause:

gFmtOpt.AndOrUnderWhere Type: Boolean Default: false

Example format options:

NameValue
gFmtOpt.AndOrUnderWherefalse

Formatted SQL:

SELECT e.employee_id,
       e.last_name,
       e.department_id,
       d.department_id,
       d.locatioin_id 
FROM   employees e,departments d 
WHERE  e.department_id = d.department_id 
       AND e.last_name = 'Matos'; 


Example format options:

NameValue
gFmtOpt.AndOrUnderWheretrue

Formatted SQL:

SELECT e.employee_id,
       e.last_name,
       e.department_id,
       d.department_id,
       d.locatioin_id 
FROM   employees e,departments d 
WHERE  e.department_id = d.department_id 
   AND e.last_name = 'Matos';