Shulou(Shulou.com)05/31 Report--

This article introduces the knowledge of "how to use Navicat Premium to export database table structure information to Excel". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Because to write a design document, you need to use the database table structure, and you want to display it in the form of a two-dimensional table in the word document, so it is very convenient to form a two-dimensional table style with the help of Excel.

1. Create a new query and modify the following SQL statement to require

SELECT COLUMN_NAME column name, COLUMN_TYPE data type, DATA_TYPE field type, CHARACTER_MAXIMUM_LENGTH length, whether IS_NULLABLE is empty, COLUMN_DEFAULT default value, COLUMN_COMMENT remarks FROM INFORMATION_SCHEMA. COLUMNSWHERE-fill in the database name of the table structure to be exported table_schema =''AND-table name, fill in the name of the table to be exported-if not, query the data in all tables by default table_name =''

two。 Click run to get the query result

3. Select all query results, right mouse button, select tab split values (field name and data)

4. Open a blank Excel document, Ctrl+V

~ ~

This is the end of the content of "how to export database table structure information to Excel using Navicat Premium". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

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.