Tabular Relationships in Navicat

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


source to share

2 answers

  • 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



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



All Articles