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

Editor to share with you how to add foreign keys to navicat, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

Open the design interface for creating the table, as shown in the figure:

Click the foreign key to display the foreign key setting interface, as shown in the figure:

For a custom name, the field window is displayed in the field below. Here, the fields of the table are displayed, as shown in the figure:

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

Click 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 small window of the reference field, 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:

The above is all the content of this article "how to add foreign keys to navicat". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.