e284. listing all non-sql92 keywords used by a database.txt

来自「这里面包含了一百多个JAVA源文件」· 文本 代码 · 共 24 行

A keyword is a reserved word used by the database. Database objects such as tables or columns cannot be named with a keyword. 
This example retrieves a list of keywords for a database. The keyword list from getSQLKeywords() is a comma separated list. 

    try {
        DatabaseMetaData dbmd = connection.getMetaData();
    
        // Get a list of keywords
        String[] keywords = dbmd.getSQLKeywords().split(",\\s*");
    } catch (SQLException e) {
    }

Examples in an Oracle database include: 
    ACCESS, ADD, ALTER, AUDIT, CLUSTER, COLUMN, COMMENT, COMPRESS, CONNECT, DATE,
    DROP, EXCLUSIVE, FILE, IDENTIFIED, IMMEDIATE, INCREMENT, INDEX, INITIAL,
    INTERSECT, LEVEL, LOCK, LONG, MAXEXTENTS, MINUS, MODE, NOAUDIT, NOCOMPRESS,
    NOWAIT, NUMBER, OFFLINE, ONLINE, PCTFREE, PRIOR, all_PL_SQL_reserved_ words

Examples in a MySQL database include: 
    AUTO_INCREMENT,BINARY,BLOB,ENUM,INFILE,LOAD,MEDIUMINT,OPTION,OUTFILE,REPLACE,
    SET,TEXT,UNSIGNED,ZEROFILL

 Related Examples