PhpStorm 2020.3 Help

DDL

CREATE/ALTER table

Item Description
Place the opening parenthesis Align or indent the opening parenthesis under the first keyword on the line. Select On the same line to keep the opening parenthesis on the line with the keyword.
Place elements

Change the position of elements in parentheses.

  • Same line aligned: align all members of the clause, keep the first member on the same line with a parenthesis.

  • Wrapped unindented: move all members of the clause to a new line without adding an indent.

  • Wrapped aligned: align and move all members of the clause to a new line.

  • Wrapped indented: add an indent and move all members of the clause to a new line.

Place the closing parenthesis

Change the position of the closing parenthesis.

  • At the end: place the closing parenthesis at the same line with the last element of a clause.

  • To begin: move the closing parenthesis to a new line with the last element of a clause.

  • Under opening: place the closing parenthesis under the opening parenthesis.

  • Under elements: place the closing parenthesis under aligned elements of a clause.

Align types Align types in a clause (for example, serial, char, varchar, and so on).
Align defaults Align DEFAULT constraints.
Align nullabilities Align NULL and NOT NULL constraints.
Collapse when short Join multiline short code sections. The length of a section that will be collapsed is determined automatically by PhpStorm.
Wrap alter instructions Move ALTER instructions to a new line.
Align alter instructions Align all ALTER instructions. To use this option, set the Wrap alter instructions option to Do not change.

Constraint

Item Description
Wrap CONSTRAINT Move CONSTRAINT to a new line.
Wrap KEY/CHECK Move KEY and CHECK to a new line.
Wrap REFERENCES Move REFERENCES to a new line.
Wrap cascade and deferrability Move CASCADE and DEFERRED constraints to a new line.

CREATE schema

Item Description
Indent content Add an indent before contents of the CREATE SCHEMA statement.
Minimum blank lines between declaration Set the minimum number of blank lines between declarations. If you put less lines than declared in this option, additional lines are added automatically.
Maximum blank lines between declaration Set the maximum number of blank lines between declarations. If you put more lines than declared in this option, additional lines are deleted automatically.

Views

Item Description
Wrap AS Move AS clause to a new line.
Wrap the beginning of the query Move the beginning of a query to a new line.
Indent query Add an indent before a query. The Wrap the beginning of the query option must be enabled.

Postfix options

Item Description
Wrap first option Move the first option of the postfix expression to a new line.
Wrap next option Move the second option of the postfix expression to a new line.
Indent options Add an indent before options of the postfix expression.
Align options Align all options of the postfix expression.
Last modified: 03 September 2020