Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How can I create foreign key constraints in the Repository Object Navigator?

0
10 Posted

How can I create foreign key constraints in the Repository Object Navigator?

0

You can create foreign key constraints by dragging and dropping in the Navigator. Drag the primary key tables node and drop it on the foreign key tables node. This will create a new foreign key in the table that was the target of the drop. You still have to assign columns to this constraint, but the constraint will be created. This drag-and-drop facility can be a problem if you accidentally drop a table on another table when you meant to drop it on a free space to create a diagram. While you can always delete the foreign key you accidentally create, it is best to exercise caution when performing drag and drop with tables. Another tip for using foreign keys in RON: click on the blue arrow to the left of the foreign key name in the Navigator. The selection will jump to the table definition of the table to which the foreign key points.

Related Questions

What is your question?

*Sadly, we had to bring back ads too. Hopefully more targeted.