达梦数据库 – 库、表、信息

-- 表名长度检测SQL
SELECT *,char_length(TABLE_NAME) as length from USER_TAB_COMMENTS  order by length desc;

-- 检测字段长度超长约束检测
SELECT
    t.TABLE_NAME,
    c.COLUMN_NAME,
    char_length(c.COLUMN_NAME) as charLength,
    c.DATA_TYPE,
    c.DATA_LENGTH
FROM
    USER_TABLES t
        JOIN USER_TAB_COLUMNS c ON t.TABLE_NAME = c.TABLE_NAME
ORDER BY
    t.TABLE_NAME,
    c.COLUMN_ID;