SQL Formatter Options

My Lists

The My Lists settings in the SQL Formatter Tool allow you to define specific formatting rules for custom SQL keywords that involve comma-separated lists, such as IN, conv_str, or extr_str. These settings provide control over how such lists are arranged and indented to improve readability and maintain consistency.

Sql Formatter Options Lists

Settings for Each Keyword

  1. Line 1

    • Specifies the number of items to place on the first line of the list.

  2. Line > 1

    • Specifies the number of items to place on subsequent lines after the first line.

  3. Before/After Parentheses „(“ and „)“

    • Before (: Adds a line break before the opening parenthesis.
    • After (: Adds a line break after the opening parenthesis.

  4. Align Commas

    • Ensures that commas in the list are aligned vertically for better readability.

  5. Indent

    • Indents the list items to improve clarity and align them visually.

Tips for Optimal Usage

  • Use consistent rules across similar keywords for better maintainability.
  • Enable Align Commas when working with long lists for easier scanning.
  • Adjust Line 1 and Line > 1 values based on the average length of your lists to minimize unnecessary line breaks.