SQL align option

Option used to align main keywords or list items.

Type definition

• Type name: TFmtAlign
• Available values:
  • 0: align left
  • 1: align right

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 ) ;