If you choose the Validate check box while creating a synonym reserved words are checked for. The following reserved words cannot be used as names in the created synonym:
|
Reserved Word |
|---|
|
ALIAS, ALL, ALTER, AND, ANY, AS, ASC, AUTHORIZATION, AVG |
|
BEGIN, BETWEEN, BINARY, BIT, BOTH, BY |
|
CALL, CASE, CAST, CHAR, CHARACTER, CHECK, CLOSE, COALESCE, COLFETCH, COMMIT, CONCAT, CONNECT, CORRESPONDING, COUNT, CREATE, CROSS, CURRENT, CURSOR |
|
DATABASE, DATE, DATETIME, DAY, DAYS, DEALLOCATE, DEC, DECIMAL, DECLARE, DEFAULT, DELETE, DESC, DISTINCT, DO, DOUBLE, DROP |
|
ELSE, ELSEIF, END, ESCAPE, EXCEPT, EXECUTE, EXISTS, EXPLAIN |
|
FETCH, FLOAT, FOR, FOREIGN, FROM, FULL, FUNCTION |
|
GET, GRANT, GRAPHIC, GROUP |
|
HAVING, HOUR, HOURS |
|
IF, IMAGE, INCLUDE, IN, INDEX, INDICATOR, INNER, INOUT, INSERT, INT, INTEGER, INTERSECT, INTO, IS, ITERAT |
|
JOIN |
|
KEY |
|
LEADING, LEAVE, LEFT, LIKE, LOCK, LOGICAL, LONG, LOOP |
|
MAX, MICROSECOND, MICROSECONDS, MILLISECOND, MILLISECONDS, MIN, MINUTE, MINUTES, MONEY, MONTH, MONTHS |
|
NATURAL, NOT, NULL, NULLIF, NUMBER, NUMERIC |
|
OF, ON, ONLY, OPEN, OPTIMIZE, OPTION, OR, ORDER, OUT, OUTER |
|
PACKAGE, PERCENT, PLAN, PRECISION, PREPARE, PRIMARY, PROCEDURE, PROGRAM, PURGE |
|
QUERYNO |
|
RAW, REAL, REFERENCES, REPEAT, RESET, RETURN, RETURNS, REVOKE, RIGHT, ROLLBACK, ROW, ROWS |
|
SCHEMA, SECOND, SECONDS, SELECT, SERIAL, SET, SMALLFLOAT, SMALLINT, SOME, STOGROUP, SUM, SYNONYM, SYSNAME |
|
TABLE, TABLESPACE, TEXT, THEN, TIME, TIMESTAMP, TO, TRAILING, TRUNCATE |
|
UNION, UNIQUE, UNTIL, UPDATE, USER, USER_TYPE_NAME, USING |
|
VALUES, VARBINARY, VARCHAR, VARGRAPHIC, VARYING, VIEW |
|
WHEN, WHERE, WHILE, WITH, WORK |
|
YEAR, YEARS |
| WebFOCUS | |
|
Feedback |