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 |
iWay Software |