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

Editor to share with you how to set navicat foreign keys, I hope you have something to gain after reading this article, let's discuss it together!

Open Navicat

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

Enter the table design interface at this point.

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 for which you want 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.

Sets the action when a foreign key is deleted, such as set null.

Set the operation when the foreign key is updated, such as restrict, and then click "Save" to create the foreign key.

After reading this article, I believe you have some understanding of "how to set foreign keys in navicat". If you want to know more about it, you are welcome to follow the industry information channel. Thank you for 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.