Tabular Relationships in Navicat

Question

How can I add table relationships in Navicat without using SQL queries? Is there some kind of wizard or helper to do this?

+3

steavy 17 Mar 12 at 9:06

2 answers

You can also use the era view. charts

Select a database and use it
Click "View" in the menu, then select "Chart" now you can see every table you have made.
press R to change the ratio of cursor to mode
click and drag a field (foreign key) from the table to the referenced table

0

Ohansyah Apr 19 18 at 14:35

Stephen Senkomago Musoke · Accepted Answer · 2012-03-17T09:42:17+0000

Select table, right click then select design table
First go to the Options tab and make sure your InnoDB engine maintains foreign key relationships
Then go to the Foreign Keys tab.
After adding one foreign key, save it to resolve any issues that might prevent it from being created