mysql 数据库字段&表名 注释查询

carol_gao 发布于 1 月 22 日

SELECT
    TABLE_NAME "表名",
    COLUMN_NAME "字段名称",
    COLUMN_TYPE "字段类型长度",
IF
    ( EXTRA = "auto_increment", CONCAT( COLUMN_KEY, "(", IF ( EXTRA = "auto_increment", "自增长", EXTRA ), ")" ), COLUMN_KEY ) "主外键",
    IS_NULLABLE "空标识",
    COLUMN_COMMENT "字段说明" 
FROM
    information_schema.COLUMNS 
WHERE
    TABLE_SCHEMA = 'gzh-test-sn';
SELECT
    TABLE_NAME "表名",
    TABLE_COMMENT "注释" 
FROM
    information_schema.TABLES 
WHERE
    TABLE_SCHEMA = 'gzh-test-sn';