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