Code Style. SQL
Use this page to configure formatting options for SQL files. View the result in the Preview pane on the right.
On this page:
General
Use this tab to specify certain formatting behaviors in your code. The results are displayed in the Preview pane.
Item | Description |
---|---|
Word Case | In this node, specify whether the keywords, identifiers, or quoted identifiers case should change automatically.
Click the right-hand column, and check the desired behavior on the menu to turn it on.
The possible options are:
|
Identifier quotations | Click the right-hand column, and check the desired behavior on the menu to turn it on.
The possible options are:
|
New line before/after | Use these nodes to define how many blank lines you want PyCharm to retain and insert in your code after reformatting. For each type of SQL element, select of clear the check box to the right. The results are highlighted in the Preview pane. |
New line around semicolon | Use this check box to manage line delimiters around a semicolon. |
Alignment | Select the check boxes next to the desired elements of source code to have them automatically aligned. |
Tabs and Indents
Spaces
Use this tab to specify where you want spaces in your code. To have PyCharm automatically insert a space at a location, select the check box next to this location in the list. The results are displayed in the Preview pane.
Wrapping and Braces
In this tab, customize the code style options, which PyCharm will apply when reformatting the source code. The left-hand pane contains the list of exceptions (Keep when reformatting), and placement and alignment options for the various code constructs (lists, statements, operations, annotations, etc.). The right-hand pane shows preview.
Alignment takes precedence over indentation options.
Item | Description |
---|---|
Keep When Reformatting | Use the check boxes in this node to configure exceptions that PyCharm will make when reformatting the source code. For example, by default, the Line brakes check box is selected. If your code contains lines that are shorter than a standard convention, you can convert them by disabling the Line brakes check box before you reformat the source code. |
Wrap inside | Use this node to define wrapping style for the lengthy elements. You can use different wrapping style options that are available from the drop-down list in the left-hand pane. |
Values expression | Use this option to define wrapping style for values expressions. You can use different wrapping style options that are available from the drop-down list in the left-hand pane. |
Wrapping Style Options | The wrapping style applies to the various code constructs, specified in the left-hand pane (for example, expressions, or assignment statements). From the drop-down list, select the desired wrapping style:
|
Blank Lines
Use this tab to insert blank lines into your code.
Item | Description |
---|---|
Keep Maximum Blank Lines | Use this area to specify blank lines in your code. Use In code field to enter the number of lines you want to insert. The default number is 2. |
Set From
Click this link to reveal the list of languages to be used as the base for the current language code style. So doing, only the settings that are applicable to the current language are taken. All the other settings are not affected.
This link appears in the upper-right corner of the language-specific code style page, when applicable.
Click Reset to discard changes and return to the initial set of code style settings.