Shulou(Shulou.com)06/01 Report--

Editor to share with you how to create foreign keys in navicat. I hope you will gain a lot after reading this article. Let's discuss it together.

How does navicat create a foreign key for a table?

First, open the design interface that creates the table, as shown in the figure

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

Custom name, click under the field to display the field window, which shows the fields of the table, as shown in the figure

Click the reference database to display the drop-down box list, which shows the database connection configured in Navicat, as shown in the figure

Click on the reference table to display a list of reference tables, which shows the tables in the corresponding parameter database, as shown in the figure

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

Set the operation when deleting and updating, and click Save to complete the creation of foreign keys, as shown in the figure

After reading this article, I believe you have a certain understanding of how to create table foreign keys in navicat. You want to know more about it. Welcome to follow the industry information channel. Thank you for your reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.