Show TOC Start of Content Area

Syntax documentation Keywords  Locate the document in its SAP Library 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

 

End of Content Area