Create and Modify dialogs

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 Ctrl+F6. 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.

Table editor

The upper part of the dialog lets you manage the table. In the pane on the left side, you can define its structure. On the right side you can edit its columns, associated constraints, and indexes. For more information about working with tables, see Tables.

Preview

The pane under the Preview separator 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.

Last modified: 21 February 2023