Navicat Premiumを使用して、データベースのテーブル構造情報をExcelにエクスポートする方法

SELECT
	COLUMN_NAME Column name,
	COLUMN_TYPE data type,
	DATA_TYPE field type,
	CHARACTER_MAXIMUM_LENGTH Length,
	Whether IS_NULLABLE is empty or not,
	COLUMN_DEFAULT Default value,
	COLUMN_COMMENT Remarks
FROM
	INFORMATION_SCHEMA. COLUMNS
WHERE
	-- Just fill in the name of the database from which you want to export the table structure
	table_schema = ''
AND 
-- The name of the table, fill in the name of the table to be exported
-- if not, query all tables by default
table_name = ''