SQL Formatter Options

Options

Stored Proc Variables

The Variables Options in the SQL Formatter Tool allow you to format and align variable declarations and assignments consistently in stored procedures and functions. These settings help ensure clarity and organization in variable-related SQL code.

Available Options

  1. Align Variable Declaration

    • Ensures that all variable declarations (DECLARE) are aligned vertically in the SQL script.
    • This makes it easier to scan and understand declared variables, especially in complex stored procedures.

  2. Align Variable Association Operator (=>)

    • Aligns the association operator (=>) used in constructs like parameter passing or key-value pairs in certain SQL contexts.
    • Ensures consistent alignment when multiple association operators are used.

  3. Align Assignment Operator (:=, =, *=, .=, etc.)

    • Aligns assignment operators used for assigning values to variables.
    • This includes different operators like := (PL/SQL), = (T-SQL or standard SQL), and others.
    • Helps create a clean and visually structured code layout for assignments.