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

Editor to share with you how navicat only derives the table structure, I hope you will gain a lot after reading this article, let's discuss it together!

Navicat Export Table structure tutorial

Select the database that needs to export the table structure, right, select "data transfer" in the menu displayed, click "data transfer" to select "Advanced" in the pop-up window, and uncheck the "record options" in "Advanced". In some settings, the final export table data will not export the record.

That is, check the database-"right-click -" data transfer-"Advanced -" uncheck the record option.

Recommended tutorial: navicat Picture and text tutorial

Extended data: data table structure

The data table consists of three parts: the table name, the fields in the table, and the record of the table. The design of the data table structure is to define the data table file name, determine which fields the data table contains, the field name, field type, and width of each field, and input these data into the computer.

Design table structure

● determines the table name. To ensure the uniqueness of the table name, the name of the table should be consistent with the purpose, concise, intuitive and meaningful.

● determines the field name.

The ⑴ field name is less than 64 characters long.

⑵ field names can include letters, Chinese characters, numbers, spaces, and other characters.

The ⑶ field name cannot include a period (.) , exclamation point (!), square brackets ([]), and accent (,).

The ⑷ field name cannot start with a leading space.

● determines the field type. Access provides 10 data types to meet the different needs of fields.

● determines the field properties. Such as field size, format, default values, required fields, validity rules, validity text, and indexes.

● determines the only primary key field in the table that can identify the record, that is, the primary key.

After reading this article, I believe you have a certain understanding of how navicat only exports the table structure, want to know more about it, 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.