通过sql查询mysql数据字典

SELECT
	r.TABLE_COMMENT AS "表名",
	t.TABLE_NAME AS "表名",
	t.COLUMN_NAME AS "列名",
	t.COLUMN_COMMENT AS "列名",
	t.DATA_TYPE AS "数据类型",
	t.COLUMN_TYPE AS "数据类型",
	t.IS_NULLABLE AS "非空",
	t.COLUMN_DEFAULT AS "默认值",
	t.COLUMN_KEY AS "数据类型",
	t.EXTRA AS "其他"
FROM
	information_schema.`COLUMNS` t,
	information_schema.`TABLES` r
WHERE
	t.TABLE_SCHEMA = 'creator'
AND t.TABLE_NAME = r.TABLE_NAME;