# Other

## Modify Object

| Item | Description |
| --- | --- |
| Confirm cancellation for dialogs that modify schema | Show a confirmation dialog when you close Create or Modify dialogs. Close means clicking Cancel or pressing `Escape` (Windows), `⎋` (macOS), `⎋` (IntelliJ IDEA Classic (macOS)), `⎋` (macOS System Shortcuts), `Escape` (XWin), `Escape` (GNOME), `Escape` (KDE), `Escape, Escape` (Emacs), `Escape` (Sublime Text), `⎋` (Sublime Text (macOS)), `Escape` (NetBeans), `Escape` (Visual Studio), `⎋` (Visual Studio (macOS)), `Escape` (Eclipse), `⎋` (Eclipse (macOS)). If the checkbox is cleared, the dialog closes instantly.       For more information about the dialogs, refer to  [Create and Modify dialogs](create-and-modify-dialogs.html).     |

## Refactoring

| Item | Description |
| --- | --- |
| Show preview of valid script when updating source text | Show the Object Migration dialog even if the changes in the object's source code are valid.     By default, the Object Migration dialog is displayed to confirm changes that you make to source code in objects. For example, if you [modify code in a routine or a view](modifying-source-code-of-database-objects.html#edit_source_code_of_an_object) and press Submit, you will see the Object Migration dialog with your changes highlighted.       For more information about changing database object's source code, refer to  [Modify source code of database objects](modifying-source-code-of-database-objects.html).     |

## DDL Mapping

| Item | Description |
| --- | --- |
|  Suggest dumping DDL for new mappings | Display a dialog with a suggestion to dump your data source to a DDL data source after [a DDL mapping is added](ddl-mappings.html#add_ddl_mapping).       For more information about creating DDL data sources, refer to  [DDL data sources](ddl-data-sources.html) and [DDL mappings](ddl-mappings.html).     |

## Code Generation

| Item | Description |
| --- | --- |
| Generate context templates | Select a query console in which you want to generate a context template. You can select between the following options:       * Append to existing console: add a context template to the current query console.    * In a new console: create a query console and paste a context template to this query console.    |

## Virtual Foreign Keys

| Item | Description |
| --- | --- |
| Column patterns pane |    Create a rule according to which IntelliJ IDEA will point a column in one table to a column in another table.       For more information about virtual foreign keys, refer to  [Virtual foreign keys](virtual-foreign-keys.html).     |

## SQL Resolution

| Item | Description |
| --- | --- |
|  Default resolve mode for consoles |     Select a default [resolve mode](run-a-query.html#resolve_modes) to resolve the database objects in query consoles.     |

## Editor

| Item | Description |
| --- | --- |
| Statement delimiter |    Sets a custom delimiter that defines the end of a statement in addition to the semicolon `;`.    |