导出关系型数据库中表及表字段详情

SenCube

于 2024-04-26 17:06:11 发布

阅读量167

点赞数 1

分类专栏： Mysql 数据库文章标签：数据库 mysql

本文链接：https://blog.youkuaiyun.com/LHS__BRU_745/article/details/138224415

版权

数据库同时被 2 个专栏收录

17 篇文章

订阅专栏

Mysql

9 篇文章

订阅专栏

SELECT TABLE_NAME as '表名称', COLUMN_NAME as '字段名', DATA_TYPE as '字段类型', CHARACTER_MAXIMUM_LENGTH as '字段长度', IS_NULLABLE as '是否可为空', COLUMN_COMMENT as '备注'
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'schema_name'
ORDER BY TABLE_NAME, ORDINAL_POSITION;