Create and Modify dialogs

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

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 June 2023