CLion 2020.2 Help

Configure the SQL code style

You can apply and customize the SQL code style that satisfies code guidelines of your company. To see the description of SQL style options, seeCode Style. SQL.

Change code style settings

Customize formatting rules for the SQL code: alignment, wrapping, and indentation.

  1. Click File | Settings | Editor | Code Style | SQL.

  2. Select all the necessary code style settings on the available tabs.

  3. Click Apply.

Create a code style for a dialect

  1. Open Settings | Editor | Code Style | SQL.

  2. Click the Gear icon (The Gear icon), and select Duplicate.

  3. Type a name for a new style, and press Enter.

  4. Select all the necessary code style settings, and click Apply.

Configure code styles per data source

After you created a style for a dialect, you can apply this style to the data source that uses this dialect.

  1. Right-click a data source and select Properties.

  2. Click the Options tab.

  3. In the Code style drop-down menu, select a style that you want to apply.

  4. Click Apply.

Apply the original case from the declaration

CLion can format names of variables, procedures, and functions as you defined them initially. For example, if you defined the get_Amount function in the CREATE PACKAGE statement, you want the same case throughout your code, not GET_AMOUNT or get_amount.

To apply this case throughout the file, CLion must find the declaration of these variables, procedures, and functions (for example, in the CREATE PACKAGE statement). To apply the case in multiple files, create a DDL data source from these files.

Apply the declaration case for a file

  1. Open settings by pressing Ctrl+Alt+S and navigate to Editor | SQL.

  2. Select the dialect in which you want to apply the original case from the declaration.

  3. Click the Case tab and select the Use original case checkbox.

  4. Click OK.

  5. Click Code | Reformat Code or press Ctrl+Alt+L.

    On the following image, you can see Pack_1.sql and Pack_2.sql with identical code. Pack_1.sql is not reformatted. Pack_2.sql was reformatted with the Use original case checkbox enabled. In Pack_2.sql, the case from the package declaration was applied throughout the whole file.

    Enable the declaration case for a file

Apply the declaration case in multiple files

  1. Create a DDL data source from the files for which you want to apply the declaration case.

  2. Open settings by pressing Ctrl+Alt+S and navigate to Editor | SQL.

  3. Select the dialect in which you want to apply the declaration case settings.

  4. Click the Case tab and select the Use original case checkbox .

  5. Click OK.

  6. Click Code | Reformat Code or press Ctrl+Alt+L to apply the declaration case in any file of the DDL data source.

    On the following image, you can see Pack_1.sql and View_1.sql. Both files are in the DDL data source. With the Use original case checkbox enabled, when you reformat code in View_1.sql, the original case from the package declaration in Pack_1.sql is applied.

Last modified: 21 September 2020