How to export only the table structure in navicat

navicat export table structure tutorial

Select the database that needs to export the table structure, right-click, and select "Data Transfer" in the displayed menu One item, click "Data Transfer" in the pop-up window, select the "Advanced" item, uncheck "Record Options" in "Advanced", make some settings, and finally export the table data and the records will not be exported. .

　That is, select the database--"Right-click-"Data Transfer-"Advanced-"Uncheck the recording option.

Recommended tutorial: navicat graphic tutorial

##Extended information: Data table structure

The data table consists of three parts: the table name, the fields in the table and the records of the table consist of. Designing the data table structure is to define the data table file name, determine which fields the data table contains, the field names, field types, and widths of each field, and input these data into the computer.

Design table structure

##　●Determine the table name. The table name must be unique, consistent with its purpose, concise, intuitive, and meaningful.

　●Determine the field name.

　　⑴Field name length is less than 64 characters.

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

　⑶Field names cannot include periods (.), exclamation points (!), square brackets ([]) and accent marks (,).

　　⑷Field names cannot start with leading spaces.

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

　●Determine field attributes. Such as field size, format, default value, required fields, validation rules, validation text and index, etc.

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

The above is the detailed content of How to export only the table structure in navicat. For more information, please follow other related articles on the PHP Chinese website!