Create and Modify dialogs (Old UI)
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 tool window ( View | Tool Windows | Database) and select Modify Table. Alternatively, click the table name and press CtrlF6. For more use cases, see Modify.
To create a table, right-click a schema name in the Database tool window ( View | Tool Windows | Database) and navigate to New | Table. For more use cases, see Create and delete.

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.
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.
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.
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. |
Thanks for your feedback!