Apply ERD to DB
Table-structure changes made in the ERD are applied to the actual database through the DDL preview modal. The target can be a single table or multiple changed tables in the ERD.
Apply Entry Points
Apply Changes to DB in a table-node toolbar targets only the selected table. The same button in the right info panel gathers changed tables in the current ERD and sends them to the DDL preview.
| Entry Point | Target | Enabled When |
|---|---|---|
| Table node | One selected table | A Connection exists and the table has changes |
| ERD info panel | All changed tables in the ERD | At least one table in the current ERD has changes |
| Table context menu | The right-clicked table or multiple selected tables | A Connection and changes exist |
DDL Preview
The DDL preview modal shows the change list and generated DDL together. Select the items to apply, and copy the DDL when you need to review it or use it for an approval request.
| Change | Generation |
|---|---|
| New table | Generates CREATE TABLE and required FKs. |
| Deleted table | Confirms whether it is a DROP TABLE target. |
| Column changes | Reflects ADD, MODIFY, RENAME, DROP COLUMN, defaults, and generated-column changes. |
| FK/Index | Reflects FK and Index additions/deletions, DBMS-specific index types, and advanced options. |
| DBMS options | Can also reflect additional options supported by the DBMS. |
Permissions and Restrictions
If DDL restriction is enabled in project permissions, you cannot execute directly and must use the approval request flow. System Schema tables have restricted structure editing and deletion.
DROP, RENAME, and PK/FK changes can cause data loss or reference errors. On production databases, always review the preview DDL and selected items.
After Execution
When execution succeeds, the change state is saved and the DB tree list is refreshed when needed. When applying multiple tables at once, only the items selected in the preview are executed.