# Smart Keys settings: SQL

> **TL;DR**
> `File | Settings | Editor | General | Smart Keys | SQL` for Windows and Linux
>
>
>
> `IntelliJ IDEA | Settings | Editor | General | Smart Keys | SQL` for macOS
>
>
>
> `Ctrl+Alt+S` (Windows), `⌘ Comma` (macOS), `⌘ Comma` (IntelliJ IDEA Classic (macOS)), `⌘ Comma` (macOS System Shortcuts), `Ctrl+Alt+S` (XWin), `Ctrl+Alt+S` (GNOME), `Ctrl+Alt+S` (KDE), `Ctrl+Alt+S` (Emacs), `Ctrl+Alt+S` (Sublime Text), `⌘ Comma` (Sublime Text (macOS)), `Ctrl+Alt+S` (NetBeans), `Ctrl+Alt+S` (Visual Studio), `⌘ Comma` (Visual Studio (macOS)), `Ctrl+Alt+S` (Eclipse), `⌘ Comma` (Eclipse (macOS)) ![the Settings icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.expui.general.settings.svg)

Use this settings page to configure typing assistance features in SQL.

For more information about SQL support in IntelliJ IDEA, refer to  [Database Tools and SQL](relational-databases.html).

| Item | Description |
| --- | --- |
| Insert string concatenation on Enter |     You may want to turn this option off, if the DBMS you are working with supports multiline string literals:       Say, there is the following fragment for PostgreSQL `text` value `notes`:        ```SQL SET notes = 'Lightest element' ```      and the caret is in front of the word `element`.      If the option is on, and you press `Enter` (Windows), `⏎` (macOS), `⏎` (IntelliJ IDEA Classic (macOS)), `⏎` (macOS System Shortcuts), `Enter` (XWin), `Enter` (GNOME), `Enter` (KDE), `Enter` (Emacs), `Enter` (Sublime Text), `⏎` (Sublime Text (macOS)), `Enter` (NetBeans), `Enter` (Visual Studio), `⏎` (Visual Studio (macOS)), `Enter` (Eclipse), `⏎` (Eclipse (macOS)), the fragment will change to:      	   ```SQL SET notes = 'Lightest ' \|\| 'element' ```      Otherwise, the fragment will change to:    	   ```SQL SET notes = 'Lightest element' ```    |
| Close code blocks on Enter | When you start a code block with an opening keyword (BEGIN, LOOP, BEGIN TRY, and others) and press `Enter` (Windows), `⏎` (macOS), `⏎` (IntelliJ IDEA Classic (macOS)), `⏎` (macOS System Shortcuts), `Enter` (XWin), `Enter` (GNOME), `Enter` (KDE), `Enter` (Emacs), `Enter` (Sublime Text), `⏎` (Sublime Text (macOS)), `Enter` (NetBeans), `Enter` (Visual Studio), `⏎` (Visual Studio (macOS)), `Enter` (Eclipse), `⏎` (Eclipse (macOS)), the code block closes with the corresponding closing keywords (END, END LOOP, END TRY, and others).     ![Close code blocks on Enter](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_close_code_blocks_on_enter.animated.gif)  |