Code Style. SQL

Last modified: 17 June 2024

File | Settings | Editor | Code Style | SQL for Windows and Linux

WebStorm | Settings | Editor | Code Style | SQL for macOS

the Settings icon

This feature is available with the Database Tools and SQL plugin installed on the Settings | Plugins page, tab Marketplace, as described in Installing plugins from JetBrains Marketplace. Please note that it is a paid plugin.

Use this page to configure formatting options for SQL files. When you change these settings, the Preview pane shows how this will affect your code.

Read more about configuring the SQL style in Configure the SQL code style .

Item

Description

Case

Change word casing options.

Queries

Configure code style for INSERT, UPDATE, WITH, SELECT, FROM, and other query structures.

DDL

Configure code style for CREATE, ALTER, views, constraints, and other DDL structures.

Code

Configure code style for declared variables, routine arguments, routine statements, loops, and other structures.

Expressions

Configure code style for corteges, binary expressions, the CASE clause, and procedure calls.

Tabs and Indents

Configure code style for indents, TAB and SPACE characters.

Wrapping

Configure what formatting to preserve when you reformat your code.

Code Generation

Configure behavior of code generation for indexes, primary and foreign keys.