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

Editor to share with you how to set foreign keys in navicat, I believe 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!

1. Open my navicat, then find my teacher table, select it, and click 'design table'' on the menu bar.

2. Find "Foreign Keys" in the pop-up dialog box, and then stand alone.

3. Then there will be an interface for setting foreign keys, with a total of seven columns. Briefly introduce the meaning of these columns.

Name': can be left unfilled, and the system will be generated automatically if you save it later.

FieldName': is which key you want to set as a foreign key. Choose 'dept'' here

'The database associated with the Reference DadaBase': foreign key.

Reference Table': the associated table here is the dept table

'The field associated with Forgin filed Names':. Here is code.

'ondelete': is the action you choose when deleting. My choice here is setNull, which means that when the associated table is deleted, the teacher "dept field is set to null.

Onupdate': is the action you choose when you update. My choice here is CASCADE, which means that when the associated table is updated, the teacher "dept field is set to cascading updates.

4. Click 'save' to save and exit' after setting up, or click 'add Foreign Key' to add a foreign key.

Expand content

Navicat is a fast, reliable and affordable database management tool designed to simplify database management and reduce system management costs. It is designed to meet the needs of database administrators, developers and small and medium-sized enterprises. Navicat is built with an intuitive graphical user interface that allows you to create, organize, access, and share information in a secure and simple way.

Navicat is well-known in the world, widely trusted by major enterprises, government institutions and educational institutions around the world, and is a necessary working partner for practitioners from all walks of life. Since 2001, Navicat has been downloaded more than 2000000 times worldwide and has a customer base of more than 70000 users. More than 100 Fortune 500 companies are also using Navicat.

Navicat provides customers with up to 7 languages to choose from and is recognized as the most popular database front-end user interface tool in the world.

It can be used to manage and develop local or remote MySQL, SQL Server, SQLite, Oracle and PostgreSQL databases.

The functionality of Navicat is sufficient to meet all the needs of professional developers, and it is quite easy for novice database servers to learn. With a very complete graphical user interface (GUI), Navicat allows you to create, organize, access and share information in a secure and easy way.

Navicat is available on three platforms-Microsoft Windows, Mac OS X and Linux. It allows users to connect to any local or remote server and provides some practical database tools such as data model, data transfer, data synchronization, structural synchronization, import, export, backup, restore, report creation tools and scheduling to assist in managing data.

The above is all the contents of the article "how to set Foreign Keys in 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.