Deleting or Editing Database Object on a Diagram

Last modified: October 18, 2023

How to Delete Database Object from Diagram

To delete a shape from the diagram but keep a database object in the database, click the object and hit the DELETE key or right-click the object and select Remove from Diagram on 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 on 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 Object on 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. Reset 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), OK button closes the dialog and saves all changes, Cancel button closes the dialog and discards all changes. You can edit database object in this dialog just like in the object editor document.