This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

Note

: This feature is available in Enterprise, and Ultimate editions only.

Table of contents

• Create and modify objects
  • Create tables
  • Create relationships
  • Save or revert changes

Diagrams are read-only by default. You can use Edit mode to create and modify database objects directly from a diagram and apply those changes to the database.

To enable Edit mode, use the diagram context menu or click the Edit mode button on the toolbar.

Create and modify objects

In Edit mode, you can:

• create new tables
• add or modify columns
• define foreign keys
• create indexes
• adjust relationships between tables

Important: When Edit mode is enabled, diagram actions are converted into an SQL script. Review the script before saving the changes.

Create tables

To create a new table, right-click an empty area of the diagram canvas and choose Create New Table.

The table is added to the diagram and opened for configuration, where you can define columns, keys, and other properties.

After saving changes, click Refresh to update the diagram and reflect the new table structure.

Create relationships

Relationships in Edit mode are created as real database constraints.

To create a relationship, right-click a table and choose Create -> Foreign Key, then configure the foreign key in the table properties.

Alternatively, select a column in the diagram and create a foreign key from the context menu.

Once changes are saved, the diagram updates to display the new relationship between tables.

Tip: You can also create an index for a column from the context menu using New Index from Selection.

Save or revert changes

In Edit mode, changes aren’t applied automatically.

• Click Save to review the generated SQL script and apply the changes to the database.
• Click Revert to discard all changes made since the last save.

Before applying changes, you can review the SQL script and decide whether to proceed.