Editing an existing relationship

To edit an existing relationship:

1.    Double click on the corresponding graphical representation:

edit relationpng

2.    Or right-click on the relation, and select “Properties”:

relation properties

Once the relationship is in edit mode, its name, caption and the other relationship characteristics can be changed.

Characteristic

Tab

Description

Description

General

A brief textual description of the relationship

Parent Key

Joins

The unique parent table or primary key of the relationship

Child Name

Joins

The child table attribute to reference the parent key

Constraint Name

Options

A name for the constraint

On parent Update

Options

Specify if the RDBMS updates the child table reference attribute value once the parent key is updated

On parent Delete

Options

Specify if the RDBMS deletes the child table rows corresponding to a newly deleted parent key value

Notes

Notes

Brief textual notes

 

 

Note that editing the generated SQL script is not possible.

 

Available in: Free and Standard Editions