SQL Formatter Options

Options

DDL Create

The Create Table / Create Index Options in the SQL Formatter Tool allow you to format SQL CREATE statements with better structure and readability. These settings control line breaks, indentation, and keyword alignment for table and index creation queries.

Sql Formatter Options Ddl Create

Linebreaks

  1. Before „(“ / After „(„

    • Before „(„: Adds a line break before the opening parenthesis in CREATE statements.
    • After „(„: Adds a line break after the opening parenthesis.

  2. Before „)“ / After „)“

    • Before „)“: Adds a line break before the closing parenthesis in CREATE statements.
    • After „)“: Adds a line break after the closing parenthesis.

Indentation

  1. Indent Cols in Brackets

    • Indents the column definitions inside parentheses for better alignment and readability in CREATE TABLE statements.

  2. Indent Bracket

    • Adds indentation to the opening and closing parentheses, ensuring they align correctly with the rest of the SQL structure.

My CREATE Keywords Getting Linebreaks

  • This section allows you to define specific CREATE keywords that should automatically receive line breaks in the formatted output.