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