Show TOC

KeywordsLocate this document in the navigation structure

All keywords reserved by the SQL 92 and SQL 99 standards are reserved in the Open SQL grammar. You cannot use reserved keywords for column or table names.

Note

Tables not created with the table editor may have column or table names conflicting with an Open SQL keyword. To access such tables or columns, you use delimited identifiers .

Syntax

Keywords reserved by Open SQL

ABSOLUTE, ACTION, ACTOR, ADD, AFTER, ALIAS,ALL, ALLOCATE, ALTER, AND, ANY, ARE, AS, ASC, ASSERTION, ASYNC, AT, ATTRIBUTES, AUTHORIZATION, AVG, BEFORE, BEGIN, BETWEEN, BIT, BIT_LENGTH, BOOLEAN, BOTH, BREADTH, BY, CASCADE, CASCADED, CASE, CAST, CATALOG, CHAR, CHAR_LENGTH, CHARACTER, CHARACTER_LENGTH, CHECK, CLASS, CLOSE, COALESCE, COLLATE, COLLATION, COLUMN, COMMIT, COMPLETION, CONNECT, CONNECTION, CONSTRAINT, CONSTRAINTS, CONSTRUCTOR, CONTINUE, CONVERT, CORRESPONDING, COUNT, CREATE, CROSS, CURRENT, CURRENT_DATE, CURRENT_PATH, CURRENT_TIME, CURRENT_TIMESTAMP, CURRENT_USER, CURSOR, CYCLE, DATA, DATE, DAY, DEALLOCATE, DEC, DECIMAL, DECLARE, DEFAULT, DEFERRABLE, DEFERRED, DELETE, DEPTH, DESC, DESCRIBE, DESCRIPTOR, DESIGNATOR, DESTROY, DESTRUCTOR, DIAGNOSTICS, DICTIONARY, DISCONNECT, DISTINCT, DOMAIN, DOUBLE, DROP, EACH, ELEMENT, ELSE, END, END-EXEC, EQUALS, ESCAPE, EXCEPT, EXCEPTION, EXEC, EXECUTE, EXISTS, EXTERNAL, EXTRACT, FACTOR, FALSE, FETCH, FIRST, FLOAT, FOR, FOREIGN, FOUND, FROM, FULL, FUNCTION, GENERAL, GET, GLOBAL, GO, GOTO, GRANT, GROUP, HAVING, HOUR, IDENTITY, IGNORE, IMMEDIATE, IN, INDICATOR, INITIALLY, INNER, INOUT, INPUT, INSENSITIVE, INSERT, INSTEAD, INT, INTEGER, INTERSECT, INTERVAL, INTO, IS, ISOLATION, JOIN, KEY, LANGUAGE, LAST, LEADING, LEFT, LESS, LEVEL, LIKE, LIMIT, LIST, LOCAL, LOWER, MATCH, MAX, MIN, MINUTE, MODIFY, MODULE, MONTH, MOVE, MULTISET, NAMES, NATIONAL, NATURAL, NCHAR, NEW, NEW_TABLE, NEXT, NO, NONE, NOT, NULL, NULLIF, NUMERIC, OCTET_LENGTH, OF, OFF, OID, OLD, OLD_TABLE, ON, ONLY, OPEN, OPERATION, OPERATOR, OPERATORS, OPTION, OR, ORDER, OUT, OUTER, OUTPUT, OVERLAPS, PAD, PARAMETERS, PARTIAL, PATH, PENDANT, POSITION, POSTFIX, PRECISION, PREFIX, PREORDER, PREPARE, PRESERVE, PRIMARY, PRIOR, PRIVATE, PRIVILEGES, PROCEDURE, PROTECTED, PUBLIC, READ, REAL, RECURSIVE, REFERENCES, REFERENCING, RELATIVE, REPRESENTATION, RESTRICT, REVOKE, RIGHT, ROLE, ROLLBACK, ROUTINE, ROW, ROWS, SAVEPOINT, SCHEMA, SCROLL, SEARCH, SECOND, SECTION, SELECT, SENSITIVE, SEQUENCE, SESSION, SESSION_USER, SET, SIMILAR, SIZE, SMALLINT, SOME, SPACE, SPECIFIC, SQL, SQLCODE, SQLERROR, SQLEXCEPTION, SQLSTATE, SQLWARNING, START, STATE, STRUCTURE, SUBSTRING, SUM, SYMBOL, SYSTEM_USER, TABLE, TEMPLATE, TEMPORARY, TERM, TEST, THAN, THEN, THERE, TIME, TIMESTAMP, TIMEZONE_HOUR, TIMEZONE_MINUTE, TO, TRAILING, TRANSACTION, TRANSLATE, TRANSLATION, TRIGGER, TRIM, TRUE, TYPE, UNDER, UNION, UNIQUE, UNKNOWN, UPDATE, UPPER, USAGE, USER, USING, VALUE, VALUES, VARCHAR, VARIABLE, VARIANT, VARYING, VIEW, VIRTUAL, VISIBLE, WAIT, WHEN, WHENEVER, WHERE, WITH, WITHOUT, WORK, WRITE, YEAR, ZONE