¶Schema Modelling

!!! info "Requires Premium" The table designer and ER diagram are Premium features.

¶Table designer

Right-click a table → Design… to open the designer:

• Rename the table.
• Add, rename, retype and drop columns, toggling nullability.
• Edited/new/dropped rows are highlighted.
• Preview shows the exact ALTER TABLE statements that will run.
• Apply runs them in order.

ALTER TABLE `elyra`.`customers` RENAME COLUMN `country` TO `country_code`;
ALTER TABLE `elyra`.`customers` MODIFY COLUMN `name` VARCHAR(120) NOT NULL;
ALTER TABLE `elyra`.`customers` ADD COLUMN `vip` INT NULL;

!!! note DDL statements auto-commit and are applied sequentially; if one fails, the error reports how many statements had already been applied.

¶ER diagram

Open ER diagram from the command palette to see the current database as a graph:

• One node per table, listing its columns (foreign-key columns are marked).
• Relationship curves are drawn from the server's foreign-key metadata.
• Zoom (buttons or scroll), pan (drag the canvas), and drag nodes to rearrange.
• Double-click a table's header to open it in the grid.