SQL align option - sqlparser/sql-pretty-printer GitHub Wiki

Option used to align main keywords or list items.

1. Type in Delphi

TAlignOption = (aloLeft,aloRight,aloNone);

2. Type in Java

public enum TAlignOption {
	AloLeft, AloRight
}

3. Uniform Type definition

• Type name: TFmtAlign
• Available values:
  • value: 0, text: left
  • value: 1, text: right
  • value: 2, text: none

Samples

• Align left

  • Align main keywords

  SELECT e.employee_id, 
         d.location_id  
  FROM   employees e,departments d  
  WHERE  e.department_id = d.department_id  
  

  • Align list items: field name

  CREATE TABLE dbo.mytable ( low  int,
                             high int, 
                             myavg AS (low + high)/2 ) ;  
  

• Align Right

  • Align main keywords

  SELECT e.employee_id, 
         d.location_id  
    FROM employees e,departments d  
   WHERE e.department_id = d.department_id  
  

  • Align list items: field name

  CREATE TABLE dbo.mytable (   low int,
                              high int, 
                             myavg AS (low + high)/2 ) ;