Use Navicat Premium to export database table structure information to Excel

Execute sql

SELECTCOLUMN_NAME column name,COLUMN_TYPE data type,DATA_TYPE field type,CHARACTER_MAXIMUM_LENGTH length,IS_NULLABLE is empty,COLUMN_DEFAULT default value,COLUMN_COMMENT CommentsFROMINFORMATION_SCHEMA.COLUMNSWHERE-- Fill in the name of the database to export the table structuretable_schema = 'database'-- table name, fill in the name of the table to be exported-- If not written, query data in all tables by defaultAND table_name = 'tablename';

Note:

database: fill in the database name;tablename: Fill in the table to be exported to excel.

Execution result

Copy result

Click the result, ctrl+a

Copy into excel

Open a blank Excel document, Ctrl+V