DataGrip 2020.3 Help

DDL

CREATE/ALTER table

ItemDescription
Place the opening parenthesisAlign 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 typesAlign types in a clause (for example, serial, char, varchar, and so on).
Align defaultsAlign DEFAULT constraints.
Align nullabilitiesAlign NULL and NOT NULL constraints.
Collapse when shortJoin multiline short code sections. The length of a section that will be collapsed is determined automatically by DataGrip.
Wrap alter instructionsMove ALTER instructions to a new line.
Align alter instructionsAlign all ALTER instructions. To use this option, set the Wrap alter instructions option to Do not change.

Constraint

ItemDescription
Wrap CONSTRAINTMove CONSTRAINT to a new line.
Wrap KEY/CHECKMove KEY and CHECK to a new line.
Wrap REFERENCESMove REFERENCES to a new line.
Wrap cascade and deferrabilityMove CASCADE and DEFERRED constraints to a new line.

CREATE schema

ItemDescription
Indent contentAdd an indent before contents of the CREATE SCHEMA statement.
Minimum blank lines between declarationSet 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 declarationSet the maximum number of blank lines between declarations. If you put more lines than declared in this option, additional lines are deleted automatically.

Views

ItemDescription
Wrap ASMove AS clause to a new line.
Wrap the beginning of the queryMove the beginning of a query to a new line.
Indent queryAdd an indent before a query. The Wrap the beginning of the query option must be enabled.

Postfix options

ItemDescription
Wrap first optionMove the first option of the postfix expression to a new line.
Wrap next optionMove the second option of the postfix expression to a new line.
Indent optionsAdd an indent before options of the postfix expression.
Align optionsAlign all options of the postfix expression.
Last modified: 08 March 2021