# Create and Modify dialogs

In IntelliJ IDEA, Create and Modify dialogs have the same fields and functionality for a given database object. This way, you can edit the same fields when you create a new object and when you edit an existing one.

* To create a database object, right-click a data source, a database, or a schema name in the Database tool window ( `View | Tool Windows | Database` ) and navigate to `New | <database_object>`.

* To modify a database object, right-click the object name in the Database tool window ( `View | Tool Windows | Database` ) and select Modify <database_object>. Alternatively, click the object name and press `Ctrl+F6` (Windows), `⌘ F6` (macOS), `⌘ F6` (IntelliJ IDEA Classic (macOS)), `⌘ ⌥ S` (macOS System Shortcuts), `Ctrl+F6` (XWin), `Ctrl+F6` (GNOME), `Ctrl+6` (KDE), `Ctrl+F6` (Emacs), `Ctrl+F6` (Sublime Text), `Ctrl+F6` (Sublime Text (macOS)), `Ctrl+F6` (NetBeans), `Ctrl+R, S` (Visual Studio), `⌘ R, S` (Visual Studio (macOS)), `Alt+Shift+C` (Eclipse), `⌘ ⌥ C` (Eclipse (macOS)).

This topic describes the Create and Modify dialogs for the following database objects: [schemas](#schemas), [tables](#tables_and_table_objects), [columns](#columns), [keys](#keys), [foreign keys](#foreign_keys), [indexes](#indexes), [checks](#checks), [virtual columns](#virtual_columns), [virtual foreign keys](#virtual_foreign_keys), [views](#views), [users and roles](#users_and_roles), and [virtual views](#virtual_views).

Starting from IntelliJ IDEA version 2024.3, the dialogs are non-modal.

## Databases

> **Note:**
> The set of available properties of database objects depends on the database vendor. For more information about database-specific properties, refer to the official documentation of the database that you are working with.

For more information about databases, refer to the [Databases](databases.html)            topic.

![the Create database dialog](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_create_database.png)

| Item | Description |
| --- | --- |
| Name |    Sets a name for the database.      If available, click ![the Auto Generate icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/database-plugin.icons.expui.textAutoGenerate.svg) Auto Generate for the name to be generated automatically.     |
| Comment |    Adds a comment to the database.      For more information about how to view comments in   Database   tool window , refer to [View Options](database-tool-window.html#view_options).     |
| Template |     PostgreSQL-specific. Disabled by default. Defines the `IS_TEMPLATE` parameter, marking the new database as a template if enabled.     |
| Allow Connections |     PostgreSQL-specific. Enabled by default. Defines the `ALLOW_CONNECTIONS` parameter, allowing new connections to the database if enabled.     |
| Tablespace |     PostgreSQL-specific. Set the default tablespace for the new database.     |
| Owner | Defines the owner of the database. |
|   Grants pane |  ![the Add icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.expui.general.add.svg), ![the Remove icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.expui.general.remove.svg), ![the Up icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.expui.general.moveUp.svg), ![the Down icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.expui.general.moveDown.svg)  |  Use these buttons to add items, remove them, and move them up and down the list.  |
| Left part | Defines the grantee. |
| Right part |    Defines the permissions.      For more information about granting permissions to users and roles, refer to the [Users and roles](database-users-and-roles.html) topic.     |
| Preview |      The pane under the Preview separator shows the statement or statements that IntelliJ IDEA will run to achieve the result you have specified using the GUI.       You can both use this pane as a preview of the auto-generated SQL script, and to write and edit statements yourself.        * To select the settings to run the script with, click ![the Settings icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.expui.general.settings.svg) Settings.    * To close the dialog and open your SQL script in a query console, click ![the Open query in query console icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.actions.MoveTo2.svg) Open query in console.     |

## Schemas

> **Note:**
> The set of available properties of database objects depends on the database vendor. For more information about database-specific properties, refer to the official documentation of the database that you are working with.

For more information about schemas, refer to the  [Schemas](schemas.html)           topic.

![the Create schema dialog](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_create_schema.png)

| Item | Description |
| --- | --- |
| Name |    Sets a name for the schema.      If available, click ![the Auto Generate icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/database-plugin.icons.expui.textAutoGenerate.svg) Auto Generate for the name to be generated automatically.     |
| Comment |    Adds a comment to the schema.      For more information about how to view comments in   Database   tool window , refer to [View Options](database-tool-window.html#view_options).     |
| Owner | Defines the owner of the schema. |
|   Grants pane |  ![the Add icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.expui.general.add.svg), ![the Remove icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.expui.general.remove.svg), ![the Up icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.expui.general.moveUp.svg), ![the Down icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.expui.general.moveDown.svg)  |  Use these buttons to add items, remove them, and move them up and down the list.  |
| Left part | Defines the grantee. |
| Right part |    Defines the permissions.      For more information about granting permissions to users and roles, refer to the [Users and roles](database-users-and-roles.html) topic.     |
| Preview |      The pane under the Preview separator shows the statement or statements that IntelliJ IDEA will run to achieve the result you have specified using the GUI.       You can both use this pane as a preview of the auto-generated SQL script, and to write and edit statements yourself.        * To select the settings to run the script with, click ![the Settings icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.expui.general.settings.svg) Settings.    * To close the dialog and open your SQL script in a query console, click ![the Open query in query console icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.actions.MoveTo2.svg) Open query in console.     |

## Tables and table objects

The table structure editor on the upper-left side of the dialog lets you manage the objects within the table. In the objects editor on the upper-right side, you can edit properties of table's objects. The preview pane on the lower part of the dialog shows the SQL script that IntelliJ IDEA will run when you close the dialog by clicking the OK button.

![Parts of the Create and Modify dialogs](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_modify_create_dialogs.png)

1. [Table structure editor.](#table_structure_editor)

2. [Objects editor.](#objects_editor)

3. [SQL script preview pane](#preview).

### Table structure editor

In the table editor section, you can edit the table's structure by adding and deleting the objects.

* To add a new object, in the toolbar, click the Add button (![the Add icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.expui.general.add.svg)) and select the object. Alternatively, select the family node of the object that you want to add, or any other object of that type, and click the Add button (![the Add icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.expui.general.add.svg)) on the toolbar.

* By default, to edit the object in the [Objects editor](#objects_editor), double-click it. Alternatively, select it and click the Edit button (![the Edit icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.expui.general.edit.svg)) on the toolbar, or press `F4` (Windows), `⌘ ↓` (macOS), `F4` (IntelliJ IDEA Classic (macOS)), `F4` (macOS System Shortcuts), `F4` (XWin), `F4` (GNOME), `F4` (KDE), `F4` (Emacs), `F4` (Sublime Text), `F4` (Sublime Text (macOS)), `F4` (NetBeans), `F4` (Visual Studio), `⌘ ↓` (Visual Studio (macOS)), `F12` (Eclipse), `F3` (Eclipse (macOS)). To select the object for editing by clicking it in the tree, click the Edit On Selection button (![the Edit On Selection icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.expui.general.autoscrollToSource.svg)) on the toolbar.

* To delete an object, select it in the tree and click the Remove button (![the Remove icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.expui.general.remove.svg)) on the toolbar.

For more information about tables, refer to the   [Tables](working-with-the-data-editor.html)          topic.

![Table structure editor in Create and Modify dialogs](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_create_modify_dialog_table_structure_editor.png)

| Icon | Item | Shortcut | Description |
| --- | --- | --- | --- |
| ![the Add icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.expui.general.add.svg) | Add | `Alt+Insert` (Windows), `⌘ N` (macOS), `⌃ N` (IntelliJ IDEA Classic (macOS)), `⌘ N` (macOS System Shortcuts), `Alt+Insert` (XWin), `Alt+Insert` (GNOME), `Alt+Insert` (KDE), `Alt+Insert` (Emacs), `Ctrl+N` (Sublime Text), `⌘ N` (Sublime Text (macOS)), `Alt+Insert` (NetBeans), `Ctrl+N` (Visual Studio), `⌘ N` (Visual Studio (macOS)), `Alt+Insert` (Eclipse), `⌘ N` (Eclipse (macOS)) | Create a new object. |
| ![the Remove icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.expui.general.remove.svg) | Remove | `Alt+Delete` (Windows), `⌘ ⌦` (macOS), `⌘ ⌦` (IntelliJ IDEA Classic (macOS)), `⌘ ⌦` (macOS System Shortcuts), `Alt+Delete` (XWin), `Alt+Delete` (GNOME), `Alt+Delete` (KDE), `Alt+Delete` (Emacs), `Alt+Delete` (Sublime Text), `⌘ ⌦` (Sublime Text (macOS)), `Alt+Delete` (NetBeans), `Ctrl+R, D` (Visual Studio), `⌘ R, D` (Visual Studio (macOS)), `Alt+Delete` (Eclipse), `Alt+Delete` (Eclipse (macOS)) | Delete the selected object. |
| ![the Edit icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.expui.general.edit.svg) | Edit | `F4` (Windows), `⌘ ↓` (macOS), `F4` (IntelliJ IDEA Classic (macOS)), `F4` (macOS System Shortcuts), `F4` (XWin), `F4` (GNOME), `F4` (KDE), `F4` (Emacs), `F4` (Sublime Text), `F4` (Sublime Text (macOS)), `F4` (NetBeans), `F4` (Visual Studio), `⌘ ↓` (Visual Studio (macOS)), `F12` (Eclipse), `F3` (Eclipse (macOS)) | Open selected object in the object editor. |
| ![the Edit On Selection icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.expui.general.autoscrollToSource.svg) | Edit On Selection |  | Toggle between opening the object in object editor on selection and by double-clicking it. |
| ![the Back icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.expui.general.left.svg) | Back | `Ctrl+Alt+Left` (Windows), `⌘ [` (macOS), `⌘ ⌥ ←` (IntelliJ IDEA Classic (macOS)), `⌘ [` (macOS System Shortcuts), `Ctrl+Alt+Left` (XWin), `Alt+Shift+Left` (GNOME), `Ctrl+Alt+Left` (KDE), `Ctrl+Alt+Left` (Emacs), `Alt+NumPad -` (Sublime Text), `⌃ NumPad -` (Sublime Text (macOS)), `Alt+Left` (NetBeans), `Ctrl+Minus` (Visual Studio), `⌘ Minus` (Visual Studio (macOS)), `Alt+Left` (Eclipse), `⌘ [` (Eclipse (macOS)) | Previous object. |
| ![the Forward icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.expui.general.right.svg) | Forward | `Ctrl+Alt+Right` (Windows), `⌘ ]` (macOS), `⌘ ⌥ →` (IntelliJ IDEA Classic (macOS)), `⌘ ]` (macOS System Shortcuts), `Ctrl+Alt+Right` (XWin), `Alt+Shift+Right` (GNOME), `Ctrl+Alt+Right` (KDE), `Ctrl+Alt+Right` (Emacs), `Alt+Shift+NumPad -` (Sublime Text), `⌃ ⇧ NumPad -` (Sublime Text (macOS)), `Alt+Right` (NetBeans), `Ctrl+Shift+Minus` (Visual Studio), `⌘ ⇧ Minus` (Visual Studio (macOS)), `Alt+Right` (Eclipse), `⌘ ]` (Eclipse (macOS)) | Next object. |

### Objects editor

In the upper-right pane of the dialog, you can edit properties of the object.

The following table objects are available for editing in the object editor:

Tables:

> **Note:**
> The set of available properties of database objects depends on the database vendor. For more information about database-specific properties, refer to the official documentation of the database that you are working with.

For more information about tables, refer to the   [Tables](working-with-the-data-editor.html)          topic.

![Create a new table](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_create_new_table.png)

| Item | Description |
| --- | --- |
| Name |    Sets a name for the table.      If available, click ![the Auto Generate icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/database-plugin.icons.expui.textAutoGenerate.svg) Auto Generate for the name to be generated automatically.     |
| Comment |    Adds a comment to the table.      For more information about how to view comments in   Database   tool window , refer to [View Options](database-tool-window.html#view_options).     |
| Owner | Defines the owner of the table. |
|   Grants pane |  ![the Add icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.expui.general.add.svg), ![the Remove icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.expui.general.remove.svg), ![the Up icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.expui.general.moveUp.svg), ![the Down icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.expui.general.moveDown.svg)  |  Use these buttons to add items, remove them, and move them up and down the list.  |
| Left part | Defines the grantee. |
| Right part |    Defines the permissions.      For more information about granting permissions to users and roles, refer to the [Users and roles](database-users-and-roles.html) topic.     |

Columns:

> **Note:**
> Column properties depend on the database vendor. For example, the Auto Increment checkbox is only available for SQLite, MySQL, and other vendors that allow it for a primary key column of an integer data type.

For more information about columns, refer to the    [Columns](columns.html)         topic.

![Add a column](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_add_new_column.png)

| Item | Description |
| --- | --- |
| Name |    Sets a name for the column.      If available, click ![the Auto Generate icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/database-plugin.icons.expui.textAutoGenerate.svg) Auto Generate for the name to be generated automatically.     |
| Comment |    Adds a comment to the column.      For more information about how to view comments in   Database   tool window , refer to [View Options](database-tool-window.html#view_options).     |
| Data Type | Sets a data type for the column. |
| Not Null | Defines whether a cell value can be null. |
| Default Expression | Sets a default expression for the column cell values. |

#### Auto-generated values

Value generation is defined in the database, for example, by using default expressions, sequences, or auto-increment settings.

The available options depend on the database vendor. For details, refer to the documentation for your DBMS.

Keys:

> **Note:**
> The set of available properties of database objects depends on the database vendor. For more information about database-specific properties, refer to the official documentation of the database that you are working with.

For more information about keys, refer to the     [Primary keys](primary-keys.html)        topic.

![Create a primary key](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_create_primary_key.png)

| Item | Description |
| --- | --- |
| Name |    Sets a name for the key.      If available, click ![the Auto Generate icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/database-plugin.icons.expui.textAutoGenerate.svg) Auto Generate for the name to be generated automatically.     |
| Comment |    Adds a comment to the key.      For more information about how to view comments in   Database   tool window , refer to [View Options](database-tool-window.html#view_options).     |
| Primary | Makes the key a primary one. |
|  Columns  pane |  ![the Add icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.expui.general.add.svg), ![the Remove icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.expui.general.remove.svg), ![the Up icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.expui.general.moveUp.svg), ![the Down icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.expui.general.moveDown.svg)  |  Use these buttons to add items, remove them, and move them up and down the list.  |
| Column Name | Sets which column to use in current table. |
| Target Name | Sets which column to use in target table. |

Foreign keys:

> **Note:**
> The set of available properties of database objects depends on the database vendor. For more information about database-specific properties, refer to the official documentation of the database that you are working with.

For more information about foreign keys, refer to the      [Foreign keys](foreign-keys.html)       topic.

![Create a foreign key](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_create_foreign_key.png)

| Item | Description |
| --- | --- |
| Name |    Sets a name for the key.      If available, click ![the Auto Generate icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/database-plugin.icons.expui.textAutoGenerate.svg) Auto Generate for the name to be generated automatically.     |
| Comment |    Adds a comment to the key.      For more information about how to view comments in   Database   tool window , refer to [View Options](database-tool-window.html#view_options).     |
| Target Table | Sets the target table. |
|  Columns  pane |  ![the Add icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.expui.general.add.svg), ![the Remove icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.expui.general.remove.svg), ![the Up icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.expui.general.moveUp.svg), ![the Down icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.expui.general.moveDown.svg)  |  Use these buttons to add items, remove them, and move them up and down the list.  |
| Column Name | Sets which column to use in current table. |
| Target Name | Sets which column to use in target table. |
| Deferrable |  Defines whether a foreign key checking can be postponed until the end of the transaction. Otherwise, it will be checked after every statement.  |
| Initially Deferred |  Sets a foreign key to be checked only at the end of the transaction. Otherwise, it will be checked after every statement.  |
| On Delete | Sets a referential action to be performed once a referenced row is deleted. |
| On Update | Sets a referential action to be performed once a referenced row is updated. |

Indexes:

> **Note:**
> The set of available properties of database objects depends on the database vendor. For more information about database-specific properties, refer to the official documentation of the database that you are working with.

For more information about indexes, refer to the       [Indexes](indexes.html)      topic.

![Create an index](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_create_index.png)

| Item | Description |
| --- | --- |
| Name |    Sets a name for the index.      If available, click ![the Auto Generate icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/database-plugin.icons.expui.textAutoGenerate.svg) Auto Generate for the name to be generated automatically.     |
| Comment |    Adds a comment to the index.      For more information about how to view comments in   Database   tool window , refer to [View Options](database-tool-window.html#view_options).     |
| Unique | Defines whether the index is unique. |
|  Columns  pane |  ![the Add icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.expui.general.add.svg), ![the Remove icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.expui.general.remove.svg), ![the Up icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.expui.general.moveUp.svg), ![the Down icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.expui.general.moveDown.svg)  |  Use these buttons to add items, remove them, and move them up and down the list.  |
| Column Name | Sets which column to use in current table. |
| Order | Defines in which order the data is stored. |
| Collation | Defines how the data is sorted and compared. |

Checks:

> **Note:**
> The set of available properties of database objects depends on the database vendor. For more information about database-specific properties, refer to the official documentation of the database that you are working with.

![Create a check](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_create_check.png)

| Item | Description |
| --- | --- |
| Name |    Sets a name for the check.      If available, click ![the Auto Generate icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/database-plugin.icons.expui.textAutoGenerate.svg) Auto Generate for the name to be generated automatically.     |
| Comment |    Adds a comment to the check.      For more information about how to view comments in   Database   tool window , refer to [View Options](database-tool-window.html#view_options).     |
| Predicate | Defines an expression used to specify the allowed cell values. |

Virtual columns:

For more information about virtual columns, refer to the         [Virtual columns](virtual-columns.html)    topic.

![Create a virtual column](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_create_virtual_column.png)

| Item | Description |
| --- | --- |
| Name |    Sets a name for the virtual column.      If available, click ![the Auto Generate icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/database-plugin.icons.expui.textAutoGenerate.svg) Auto Generate for the name to be generated automatically.     |
| Expression |    Defines the expression used to calculate values.       The expression used to calculate values for virtual column is stored in `external-data-<data_source_name>.xml`. You can select another name for the XML file and other place to store this file. To change or see the path to the XML document, open data source settings by pressing   `Shift+Enter` (Windows), `⌘ I` (macOS), `⇧ ⏎` (IntelliJ IDEA Classic (macOS)), `⌘ I` (macOS System Shortcuts), `Shift+Enter` (XWin), `Shift+Enter` (GNOME), `Shift+Enter` (KDE), `Shift+Enter` (Emacs), `Shift+Enter` (Sublime Text), `⌘ I` (Sublime Text (macOS)), `Shift+Enter` (NetBeans), `Shift+Enter` (Visual Studio), `⌘ I` (Visual Studio (macOS)), `Shift+Enter` (Eclipse), `⌘ I` (Eclipse (macOS)) , click the Options tab and see the Virtual objects and attributes field.      |

Virtual foreign keys:

The virtual foreign key relation is stored in `external-data-<data_source_name>.xml`. You can select another name for the XML file and other place to store this file. To change or see the path to the XML document, open data source settings by pressing   `Shift+Enter` (Windows), `⌘ I` (macOS), `⇧ ⏎` (IntelliJ IDEA Classic (macOS)), `⌘ I` (macOS System Shortcuts), `Shift+Enter` (XWin), `Shift+Enter` (GNOME), `Shift+Enter` (KDE), `Shift+Enter` (Emacs), `Shift+Enter` (Sublime Text), `⌘ I` (Sublime Text (macOS)), `Shift+Enter` (NetBeans), `Shift+Enter` (Visual Studio), `⌘ I` (Visual Studio (macOS)), `Shift+Enter` (Eclipse), `⌘ I` (Eclipse (macOS)) , click the Options tab and see the Virtual objects and attributes field.

For more information about virtual foreign keys, refer to the        [Virtual foreign keys](virtual-foreign-keys.html)     topic.

![Create a virtual foreign key in the Modify dialog](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_create_virtual_foreing_key_in_modify_dialog.png)

| Item | Description |
| --- | --- |
| Name |    Sets a name for the virtual key.      If available, click ![the Auto Generate icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/database-plugin.icons.expui.textAutoGenerate.svg) Auto Generate for the name to be generated automatically.     |
| Target Table |    Sets the target table.    |
|  Columns  pane |  ![the Add icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.expui.general.add.svg), ![the Remove icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.expui.general.remove.svg), ![the Up icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.expui.general.moveUp.svg), ![the Down icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.expui.general.moveDown.svg)  |  Use these buttons to add items, remove them, and move them up and down the list.  |
| Column Name | Sets which column to use in current table. |
| Target Name | Sets which column to use in target table. |

### Preview

The pane under the Preview separator shows the statement or statements that IntelliJ IDEA will run to achieve the result you have specified using the GUI.

You can both use this pane as a preview of the auto-generated SQL script, and to write and edit statements yourself.

* To select the settings to run the script with, click ![the Settings icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.expui.general.settings.svg) Settings.

* To close the dialog and open your SQL script in a query console, click ![the Open query in query console icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.actions.MoveTo2.svg) Open query in console.

![Object editor tabs in the Modify dialog](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_modify_create_dialogs_preview_pane.png)

### Productivity tips

Pin the object tabs
: To pin the tab with the current object, hover over the tab name and click the Pin Tab icon (![the Pin icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.expui.general.pin.svg)). Alternatively, right-click the tab name and select Pin Tab.
:
:
:
: ![Objects editor tabs in the Modify dialog](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_modify_create_dialogs_context_menu_objects_editor.png)

Use context menu of table objects
: You can also use manage the objects using their context menu.
:
:
:
: ![Manage objects in a Modify dialog using a context menu](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_modify_create_dialogs_context_menu.png)

View similar objects list
: The Modify dialog can display objects of the same kind in a list. To see that list, in the left pane of the dialog, double-click the family node.
:
:
:
: ![Table with similar database objects in a family node of a Modify dialog](https://resources.jetbrains.com.cn/help/img/idea/2026.2/similar_objects_table_in_family_nodes.png)

## Views

> **Note:**
> The set of available properties of database objects depends on the database vendor. For more information about database-specific properties, refer to the official documentation of the database that you are working with.

For more information about views, refer to the          [Views](views.html)   topic.

![Create a view](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_create_view.png)

| Item | Description |
| --- | --- |
| Name |    Sets a name for the view.      If available, click ![the Auto Generate icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/database-plugin.icons.expui.textAutoGenerate.svg) Auto Generate for the name to be generated automatically.     |
| Comment |    Adds a comment to the view.      For more information about how to view comments in   Database   tool window , refer to [View Options](database-tool-window.html#view_options).     |
| Owner | Defines the owner of the view. |
| Source Text | Defines the statement used to create the view. |
|   Grants pane |  ![the Add icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.expui.general.add.svg), ![the Remove icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.expui.general.remove.svg), ![the Up icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.expui.general.moveUp.svg), ![the Down icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.expui.general.moveDown.svg)  |  Use these buttons to add items, remove them, and move them up and down the list.  |
| Left part | Defines the grantee. |
| Right part |    Defines the permissions.      For more information about granting permissions to users and roles, refer to the [Users and roles](database-users-and-roles.html) topic.     |
| Preview |      The pane under the Preview separator shows the statement or statements that IntelliJ IDEA will run to achieve the result you have specified using the GUI.       You can both use this pane as a preview of the auto-generated SQL script, and to write and edit statements yourself.        * To select the settings to run the script with, click ![the Settings icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.expui.general.settings.svg) Settings.    * To close the dialog and open your SQL script in a query console, click ![the Open query in query console icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.actions.MoveTo2.svg) Open query in console.     |

## Users and roles

> **Note:**
> The set of available properties of database objects depends on the database vendor. For more information about database-specific properties, refer to the official documentation of the database that you are working with.

For more information about users and roles, refer to the           [Users and roles](database-users-and-roles.html)  topic.

![Create a user](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_create_user_or_role.png)

| Item | Description |
| --- | --- |
| Name |    Sets a name for the user or role.      If available, click ![the Auto Generate icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/database-plugin.icons.expui.textAutoGenerate.svg) Auto Generate for the name to be generated automatically.     |
| Comment |    Adds a comment to the user or role.      For more information about how to view comments in   Database   tool window , refer to [View Options](database-tool-window.html#view_options).     |
| Create DB | Determines whether the user can create new databases or not. |
|   Grants pane |  ![the Add icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.expui.general.add.svg), ![the Remove icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.expui.general.remove.svg), ![the Up icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.expui.general.moveUp.svg), ![the Down icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.expui.general.moveDown.svg)  |  Use these buttons to add items, remove them, and move them up and down the list.  |
| Left part | Defines the grantee. |
| Right part |    Defines the permissions.      For more information about granting permissions to users and roles, refer to the [Users and roles](database-users-and-roles.html) topic.     |
| Preview |      The pane under the Preview separator shows the statement or statements that IntelliJ IDEA will run to achieve the result you have specified using the GUI.       You can both use this pane as a preview of the auto-generated SQL script, and to write and edit statements yourself.        * To select the settings to run the script with, click ![the Settings icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.expui.general.settings.svg) Settings.    * To close the dialog and open your SQL script in a query console, click ![the Open query in query console icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.actions.MoveTo2.svg) Open query in console.     |

## Virtual views

For more information about virtual views, refer to the          [Views](views.html)   topic.

![Create a virtual view](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_create_virtual_view.png)

| Item | Description |
| --- | --- |
| Name |    Sets a name for the virtual view.      If available, click ![the Auto Generate icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/database-plugin.icons.expui.textAutoGenerate.svg) Auto Generate for the name to be generated automatically.     |
| Query |    Defines the SQL statements that are used to get a result set.       The SQL statement of virtual view is stored in `external-data-<data_source_name>.xml`. You can select another name for the XML file and other place to store this file. To change or see the path to the XML document, open data source settings by pressing   `Shift+Enter` (Windows), `⌘ I` (macOS), `⇧ ⏎` (IntelliJ IDEA Classic (macOS)), `⌘ I` (macOS System Shortcuts), `Shift+Enter` (XWin), `Shift+Enter` (GNOME), `Shift+Enter` (KDE), `Shift+Enter` (Emacs), `Shift+Enter` (Sublime Text), `⌘ I` (Sublime Text (macOS)), `Shift+Enter` (NetBeans), `Shift+Enter` (Visual Studio), `⌘ I` (Visual Studio (macOS)), `Shift+Enter` (Eclipse), `⌘ I` (Eclipse (macOS)) , click the Options tab and see the Virtual objects and attributes field.      |
| Preview |      The pane under the Preview separator shows the statement or statements that IntelliJ IDEA will run to achieve the result you have specified using the GUI.       You can both use this pane as a preview of the auto-generated SQL script, and to write and edit statements yourself.        * To select the settings to run the script with, click ![the Settings icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.expui.general.settings.svg) Settings.    * To close the dialog and open your SQL script in a query console, click ![the Open query in query console icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.actions.MoveTo2.svg) Open query in console.     |

## See also

### Procedures

[Schemas](schemas.html) [Tables](working-with-the-data-editor.html) [Columns](columns.html) [Primary keys](primary-keys.html) [Foreign keys](foreign-keys.html) [Indexes](indexes.html) [Virtual columns](virtual-columns.html) [Virtual foreign keys](virtual-foreign-keys.html) [Views](views.html) [Users and roles](database-users-and-roles.html) [Virtual views](virtual-views.html)

### Reference

[Database tool window](database-tool-window.html) [Data sources and their elements](database-tool-window.html#icons-for-data-sources-and-their-elements)