Online Documentation for SQL Manager for SQL server

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