|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. |
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, |
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 DataGrip.|
|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.|
|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.|
|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.|
|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.|
|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