Create and Modify dialogs

note

As of version 2022.1, the Create New Table and Modify Table dialogs are redesigned into the Create and Modify dialogs. For the previous versions design, refer to Create table and modify table dialogs (Old UI).

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 CtrlF6. 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.

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.