Skip to content

SQL indentation general

shenhuan2021 edited this page Mar 3, 2024 · 13 revisions
  • General indentation size

    Option: fmt124_indent_generic = n, type: TFmtInt.

    General indentation size is used to indent SQL code if there is no specific indent option provided for this SQL segment. Select list in following SQL was indented by 2 spaces.

    SELECT 
      lastname, 
      firstname, 
      jobtitle, 
      department  
    FROM   humanresources.vemployeedepartment;  
  • Use tab to indent

    Option: fmt125_indent_use_tab = false, type: TFmtBoolean.

    Option: fmt126_indent_tab_size = n, type: TFmtInt.

    Use tab character instead of space to indent SQL segment. Tab size means how many spaces of one tab.

  • Indentation of SQL block

Clone this wiki locally