How to create a foreign key to a table in navicat

#How does navicat create a foreign key to a table?

First open the design interface of the created table, as shown in the figure

Then click on the foreign key to display the foreign key setting interface, as shown in the figure

Customize the name, click on the field to display the field window, where the fields of the table are displayed, as shown in the figure

Click on the reference database to display the drop-down list. The database connection configured in Navicat is displayed here, as shown in the figure

Click on the reference table to display the reference table list. Displayed here is the table in the corresponding parameter database, as shown in the figure

Click the reference field to display the reference field small window, which is the field of the reference table, as shown in the figure

Set the delete and update operations, click Save to complete the foreign key creation, as shown in the figure

Related recommendations: "Navicat for mysql graphic tutorial"

The above is the detailed content of How to create a foreign key to a table in navicat. For more information, please follow other related articles on the PHP Chinese website!