PyCharm
 
Get PyCharm
You are viewing the documentation for an earlier version of PyCharm.

Create Table and Modify Table Dialogs

Last modified: 27 September 2023

In PyCharm, Create and Modify have the same fields and functionality. This way, you can edit the same fields when you create a new object and when you edit an existing one.

To modify a database object, right-click the table name in the Database tool window ( View | Tool Windows | Database) and select Modify <database object>. Alternatively, click the table name and press CtrlF6.

To create a database object, right-click a data source, a database, or a schema name in the Database tool window ( View | Tool Windows | Database) and navigate to New | <database object>.

The table structure editor on the upper-left side of the dialog lets you manage the objects within the table. In the object editor on the upper right side, you can edit properties of table's objects. The preview pane on the lower part of the dialog shows the SQL script that PyCharm will run when you close the dialog by clicking the OK button.

GUI part of the dialog