The method of creating a new table in navicat

This article mainly introduces the method of navicat new table, which is very detailed and has certain reference value. Friends who are interested must finish it!

How does navicat create a new table?

Step one

Create a new database. Creating a new database is relatively simple. Right-click in the blank area of the connection navigation bar on the left side of the Navicat navigation view (shown in the following figure) to see the command of "New Database".

Navicat right-click to create a new database

Here is an example to build a database for managing students: school, and the final effect is shown in the following figure.

Navicat New school Database

Step two

Create a new table. Once you have created a new database, you can create a data table under the database. The following figure shows the established student table: students.

Create a new example under the school database

There is not much complicated operation to create a new table in Navicat for MySQL, but there is one place to pay special attention to in the process of creating a table, that is, "field". For beginners who use Navicat for the first time, this is relatively unfamiliar. It means what we usually call "field". "add field" in the toolbar means to add a field. Don't get it mixed up. After adding all the fields, set the corresponding "primary key" according to the requirements.

If the database is more complex, we can continue to do relevant settings according to the requirements, there are indexes, foreign keys, triggers for us to call in the "field" label, and under the "SQL Preview" tag is the SQL statement, which is very useful for us to learn SQL statements.

The above is all the contents of the article "how to create a New Table in navicat". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!