Table relations in Navicat

mysql foreign-key-relationship navicat
steavy picture steavy · Mar 17, 2012 · Viewed 11k times · Source

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

Answer

Stephen Senkomago Musoke picture Stephen Senkomago Musoke · Mar 17, 2012

  1. Select the table, right click then select Design Table

  2. First go to the Options tab and ensure that your Engine is InnoDB which supports foreign key relationships

  3. Then go to the Foreign keys tab.

  4. Once you add one foreign key save it, so that you resolve any issues that may stop it from being created

Related questions

How to change the foreign key referential action? (behavior)

I have set up a table that contains a column with a foreign key, set to ON DELETE CASCADE (delete child when parent is deleted) What would the SQL command be to change this to ON DELETE RESTRICT? (can't delete …

Read More
unable to drop the foreign key

I would like to drop the foreign key in my table but been into this error message mysql> alter table customers drop foreign key customerid; ERROR 1025 (HY000): Error on rename of '.\products\customers' to '.\products\#sql2-7…

Read More
MySQL - Using foreign key as primary key too

I have table 1 with a primary key user_id and table 2 where user_id is a foreign key. Only 1 record per user_id can exist in table 2, and no record can exist without it. QUESTION: Can user_id in table 2 …

Read More