Create and Modify dialogs (Old UI)

Last modified: 21 June 2023

note

As of version 2022.1, the Create New Table and Modify Table dialogs are redesigned into the Create and Modify dialogs. For the redesigned dialogs, refer to Create and Modify Table dialogs.

To modify a table, right-click the table name in the Database Explorer ( View | Tool Windows | Database Explorer) and select Modify Table. Alternatively, click the table name and press . For more use cases, see Modify.

To create a table, right-click a schema name in the Database Explorer ( View | Tool Windows | Database Explorer) and navigate to New | Table. For more use cases, see Create and delete.

https://resources.jetbrains.com/help/img/idea/2023.1/db_modify_create_table_dialogs.png
Gif

Upper part: GUI

The upper part of the dialog you can define a table structure, associated constraints, and indexes. For more information about working with tables, see Tables.

SQL Script

The pane under SQL Script shows the statement or statements to be run to achieve the result you have specified using the GUI.

You can use this pane just as a preview. You can also edit the statement or statements right there.

Options

Item

Description

Execute in database

Change data structure in your database by running the statement or statements.

Execute: execute the statements right away. If associated changes in database consoles are possible, the corresponding preview is shown.

Preview: preview potential associated changes prior to executing the statements.

Open in editor

Copy the statements into the corresponding query console or SQL file.

  • Modify existing objects: in the generated set of statements, ALTER statements are preferred to CREATE statements.

  • Create modified objects: the changes you have made using the GUI are translated into a minimal set of CREATE and other statements.

  • Create all objects: the generated set always includes the CREATE TABLE statement, as if the whole table were created anew.

To Editor: switch to the corresponding editor tab right away. If associated changes are possible, the corresponding preview is shown prior to copying the statements.

Preview: preview potential associated changes.

See also

Procedures