The method of setting primary key by navicat

Editor to share with you the method of setting the primary key of 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!

Step one, open Navicat.

The second step is to open the database where the data table is located, right-click the database table that needs to add fields, and then click "Design Table".

All the fields of the table are listed.

Third, select the field that is the primary key, such as the code field.

Step 4, click "Primary key" under the "object" menu, and the code field becomes the primary key and is automatically set to non-empty.

Step 5, set the default value of the primary key below, comment, whether to increment automatically, etc., and then click "Save", and the new primary key setting is completed.

The above is all the content of this article "how to set the primary key 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!