DDL
Configure code style for CREATE
, ALTER
, views, constraints, and other DDL structures.
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.
|
Place the closing parenthesis | Change the position of the closing parenthesis.
|
Align types | Align types in a clause (for example, |
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 JetBrains Rider. |
Wrap alter instructions | Move |
Align alter instructions | Align all |
Item | Description |
---|---|
Wrap CONSTRAINT | Move CONSTRAINT to a new line. |
Wrap KEY/CHECK | Move KEY and |
Wrap REFERENCES | Move REFERENCES to a new line. |
Wrap cascade and deferrability | Move CASCADE and DEFERRED constraints to a new line. |
Item | Description |
---|---|
Indent content | Add an indent before contents of the |
Minimum blank lines between declaration | Set the minimum number of blank lines between declarations. If you put fewer 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. |
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. |
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. |