查询数据库元数据


SELECT
table_name,
column_name,
column_comment,
data_type,
column_type
FROM
information_schema. COLUMNS
WHERE
TABLE_SCHEMA = 'ssr'
ORDER BY
TABLE_NAME,
ORDINAL_POSITION

原文地址:https://www.cnblogs.com/huanghuanghui/p/9017862.html