获取 onemap 库中所有的表名、表注释

-- 获取 onemap 库中所有的表名、表注释
SELECT
    T1.TABLE_NAME 表名,
    T1.TABLE_COMMENT 表注释
FROM 
    INFORMATION_SCHEMA.TABLES T1
WHERE  
    T1.TABLE_SCHEMA ='onemap'
-- AND 
--     T1.TABLE_NAME LIKE 'oemp%'
ORDER BY 
    T1.TABLE_NAME;


-- 获取 onemap 库中所有的表名、表注释、字段详细信息
SELECT
    T1.TABLE_NAME 表名,
    T1.TABLE_COMMENT 表注释,
    T1.TABLE_ROWS 表数据量,
    T2.COLUMN_NAME 字段名,  
    T2.COLUMN_TYPE 数据类型,  
    T2.DATA_TYPE 字段类型,  
    T2.CHARACTER_MAXIMUM_LENGTH 长度,  
    T2.IS_NULLABLE 是否为空,  
    T2.COLUMN_DEFAULT 默认值,  
    T2.COLUMN_COMMENT 字段备注   
FROM 
    INFORMATION_SCHEMA.TABLES T1
LEFT JOIN
    INFORMATION_SCHEMA.COLUMNS T2
ON
    T1.TABLE_NAME = T2.TABLE_NAME
WHERE  
    T1.TABLE_SCHEMA ='onemap'
-- AND 
--     T1.TABLE_NAME LIKE 'oemp%'
ORDER BY 
    T1.TABLE_NAME;