EMS logo

Produkt Navigation

SQL Manager for PostgreSQL

Unsere Partnerschaften

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for PostgreSQL

Online Bedienungsanleitung

Creating relations


To establish a new relation (which is the foreign key in terms of database management):

  • press the Create relation button on the New object toolbar;
  • click the entity where the referential constraint should be created;
  • click the referred entity;
  • specify new foreign key properties using Foreign key Editor.

 

VDBD - Creating relations

 

 

Hint: To create a relation, you can also use the corresponding item of the context menu.

 

 

Once the relation is created, it is displayed as a line between two entities in the diagram area. The style the line is drawn is determined by the diagram notation.

The context menu of this line allows you to edit the foreign key using Foreign key Editor or drop the foreign key from the database.

 

VDBD - Creating relations - Context menu

 

 


See also:

Using Navigation bar and Toolbars

Using Diagram Navigator and DB Objects pane

Using context menus

Adding/removing objects to/from diagram

Incremental search

Creating new objects

Working with diagram pages

Reverse engineering

Printing diagram

Saving/loading diagram

Setting diagram options