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

This article is about navicat's method of setting foreign keys. Xiao Bian thinks it is quite practical, so share it for everyone to make a reference. Let's follow the editor and have a look.

Open Navicat.

Open the database where the data table is located, right-click the database table where you want to add fields, and then click Design Table.

Enter the table design interface.

Click the Foreign Key tab and enter the name of the foreign key, such as product id.

In the field selection dialog box, select the field to create a foreign key, such as the productid field, and then click OK.

Select a reference database, such as sparrow.

Select a reference table, such as product.

Select a reference field, such as product_id.

Set the operation when deleting foreign keys, such as set null.

Set the operation when updating foreign key, such as restrict, and then click Save to complete the creation of foreign key.

Thank you for reading! About navicat set foreign key method to share here, I hope the above content can be of some help to everyone, so that we can learn more knowledge. If you think the article is good, you can share it so that more people can see it!

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.