查询数据库元数据


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

posted @ 2018-05-10 08:57  huanghaunghui  阅读(255)  评论(0)    收藏  举报