Editing Properties

You can edit the detailed properties regarding with the elements of the diagram using the properties dialog windows. Most of the properties dialog windows can be executed by SPACE or Pop-up Menu > Properties after selecting a target.

Via properties window, you can edit some physical properties provided the target DBMS, other than detailed traits of E-R model.

Properties for Table

After selecting a table, press SPACE or click Pop-up Menu > Properties.

• You can edit general properties of corresponding table and physical properties of DBMS.
• You can edit all the information of corresponding table such as columns, constraints, relationships, indexes, and so on.



This screenshots is a case of setting target DBMS to Oracle.

Properties for Column

After selecting a column, press SPACE or click Pop-up Menu > Properties.

• Columns of the corresponding table are shown and the target column is selected.



This screenshots is a case of setting target DBMS to Oracle.

Properties for Relationship

After selecting a relationship line, press SPACE or click Pop-up Menu > Properties.

• Relationships of the referenced tables are shown and the target relationship is selected.
• You can change child columns(FK) included in the relationship.

DBMS-Specific Properties

For some DBMS-specific properties, refer to the following links:

• Oracle
  • Editing Tablespace Properties
  • Editing Table Properties
  • Editing View Properties
  • Editing Trigger Properties
  • Editing Function Properties
  • Editing Procedure Properties
  • Editing Column Properties
  • Editing Indexes and Constraints
• Microsoft SQL Server
  • Editing Database Properties
  • Editing Table Properties
  • Editing View Properties
  • Editing Trigger Properties
  • Editing Function Properties
  • Editing Procedure Properties
  • Editing Column Properties
  • Editing Indexes and Constraints
• IBM DB2
  • Editing Database Properties
  • Editing Schema Properties
  • Editing Table Properties
  • Editing View Properties
  • Editing Trigger Properties
  • Editing Function Properties
  • Editing Procedure Properties
  • Editing Column Properties
  • Editing Indexes and Constraints
• MySQL
  • Editing Database Properties
  • Editing Schema Properties
  • Editing Table Properties
  • Editing View Properties
  • Editing Trigger Properties
  • Editing Function Properties
  • Editing Procedure Properties
  • Editing Column Properties
  • Editing Indexes and Constraints
  • Editing Partition Properties