Home  >  Article  >  Database  >  How to export table structure in navicat

How to export table structure in navicat

(*-*)浩
(*-*)浩Original
2019-08-13 11:09:3431157browse

How to export table structure in navicat

Navicat exports the table structure

Step 1: Open Navicat and connect to MySQL (recommended tutorial: navicat tutorial)

How to export table structure in navicat

As shown below, click Connect to MySQL and enter the connection name and password.

How to export table structure in navicat

Step 2: Open the database and export the table structure

Here we have a file named php Right-click on this database. After right-clicking, you can see the related properties shown in the figure below. Select the dump sql file, and then select [Structure Only] according to your own export requirements for the database. (Dumping the sql file means exporting the sql file)

How to export table structure in navicat

Step 3: Select the location where the sql file is saved

How to export table structure in navicat

As shown in the figure below, the sql file is successfully exported.

How to export table structure in navicat

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

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn