Edit

Use ER Design

View Table Objects

Supports :

This section explains how to view table objects.

1. Connect to database.
2. On the main menu bar, go to File>New>ER Design. Or, click [ER Design] on the New Toolbar.
3. Select a schema. Then, select tables and drag them to canvas. Or, click [Add].
4. On canvas, check the added tables.

Find Table Objects On Canvas

Supports :

This section explains how to find table objects on canvas.

1. Connect to database.
2. On the main menu bar, go to File>New>ER Design, or simply click [ER Design] on the New Toolbar.
3. Specify a schema and select a table. Drag to canvas or click [Add].
4. On the main menu bar, go to Edit>Find and Replace>Find or press Ctrl+F.
5. Enter the name of the table on the Search window.

6. Check the search results.

View Relationship Between Tables

Supports :

This section explains how to view a relationship between tables.

1. Connect to database.
2. On the main menu bar, go to File>New>ER Design. Or, click [ER Design] on the New Toolbar.
3. Select a schema. Then, select tables and drag them on canvas. Or, click [Add].
4. Double-click the link between a table and an object.
5. Check the relationship between a table and an object.

Alter Relationships Between Table Objects

Supports :

This section explains how to alter table objects.

1. Connect to database.
2. On the main menu bar, go to File>New>ER Design. Or, click [ER Design] on the New Toolbar.
3. Select a schema. Then, select tables and drag them to canvas. Or, click [Add].
4. On the Toolbar, click one from: 1:1 Non-identifying Relationship, 1:n Non-identifying Relationship, and n:m Non-identifying Relationship.
5. Click the original table and then the destination table.
6. You will see a link created between the tables.
7. Set a Relationship Key.
8. Click [Ok].

Note: Logical relationships between table objects will be linked in dotted line.

Change Options for Table Display

Supports :

This section explains how to change table view options.

1. Connect to database.
2. On the main menu bar, go to File>New>ER Design. Or, click [ER Design] on the New Toolbar.
3. Select a schema. Then, select tables and drag them to canvas. Or, click [Add].
4. Double-click a table object. You will see Change Options for Table Display window.

5. Set values to display. Click [OK].
6. Check the result.

ER Design Toolbar

Supports :

Button	Instruction	Shortcut keys	Action
	Select		Select object with left mouse button drag.
	Move		Move selected objects.
	Resize		Resize the selected group.
	Delete		Delete the selected object.
	Panning Hand		Left-click on workspace and move.
	Zoom Out		View workspace smaller.
	Zoom In		Zoom in to workspace.
	Region		Groups related objects together.
	Text Box		Add text or comment on canvas.
	1:1 Non-identifying Relationship		Set 1:1 non-identifying relationships between objects in a table.
	1:n Non-identifying Relationship		Set 1:n non-identifying relationships between objects in a table.
	n:m Non-identifying Relationship		Set n:m non-identifying relationships between objects in a table.
	View SQL		View current ER Design script.
	Refresh		Refresh canvas.