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.
Table structure editor
In the table editor section, you can edit the table's structure by adding and deleting the objects.
To add a new objects, in the toolbar, click the Add button () and select the object. Alternatively, select the family node of the object that you want to add, or any of the existing objects of that kind, and click the Add button () on the toolbar.
By default, to edit the object in the Object editor, double-click it. Alternatively, select it and click the Edit button () on the toolbar, or press F4.
To select the object for editing by clicking it in the tree, click the Edit On Selection button () on the toolbar.
To delete an object, select it in the tree and click the Remove button () on the toolbar.
tip
You can also use manage the objects using their context menu.
The Modify dialog can display objects of the same kind in a list. To see that list, in the left pane of the dialog, double-click on the family node.
Object editor
In the upper right pane of the dialog, you can edit properties of the object.
The set of available properties of database objects depends on the database vendor. For more information about database-specific settings, refer to the official documentation of the database that you are working with.
To pin the tab with the current object, hover over the tab name and click the Pin Tab icon (). Alternatively, right-click the tab name and select Pin Tab.
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.
Reference
Icon
Item
Shortcut
Description
Table structure editor
Add
AltInsert
Create a new object.
Remove
AltDelete
Delete the selected object.
Edit
F4
Open selected object in the object editor.
Edit On Selection
Toggle between opening the object in object editor on selection and by double-clicking it.
Back
CtrlAlt0←
Previous object.
Forward
CtrlAlt0→
Next object.
Object editor
Auto Generate
Toggle the object name automatic generation.
Preview pane
Settings
Select the settings to run the script with.
Open query in console
Close the Modify dialog and open the script in a query console.
Our website uses some cookies and records your IP address for the purposes of accessibility, security, and managing your access to the telecommunication network. You can disable data collection and cookies by changing your browser settings, but it may affect how this website functions. Learn more.
With your consent, JetBrains may also use cookies and your IP address to collect individual statistics and provide you with personalized offers and ads subject to the Privacy Notice and the Terms of Use. JetBrains may use third-party services for this purpose. You can adjust or withdraw your consent at any time by visiting the Opt-Out page.