How to manipulate database objects on a diagram

Last modified: October 1, 2024

How to delete database objects from a diagram

To delete a shape from a diagram but keep the database object in the database, click the object and hit the DELETE key or right-click the object and select Remove from Diagram from the shortcut menu.

To remove database object from the database, click the object and press CTRL+DELETE or right-click the object and select Remove from Diagram from the shortcut menu.

Table columns, indexes, constraints, triggers, relations (foreign keys) can only be dropped from a database. Both DELETE and CTRL+DELETE keys invoke dropping. View columns and stored routine parameters cannot be deleted.

How to edit database objects on a diagram

To edit a database object, double-click it on the diagram. An object editor dialog will appear. The object editor dialog is the same as object editor document except for the bottom buttons. Refresh Object discards all changes to the database object on any tab of the editor (but not the changes to the table or view data on the data view), the Apply Changes button closes the dialog and saves all changes, the Script Changes button displays the script changes. You can edit database object in this dialog just like in the object editor document.