Documentation Comments
Use this form to comment on this topic. You can also provide any general observations about the Online Documentation, or request that additional information be added in a future release.
Reality V15.2 Online Documentation (MoTW) Revision 3
SQL Reserved Words (SQL) (m6915ac_.htm)
The words listed below have a special meaning to Reality SQL. They should not be used as table or column names, and cannot be used as user IDs when granting permissions to Reality SQL tables.
| ABSOLUTE | ADA | ADD | ALL |
| ALLOCATE | ALTER | AND | ANY |
| ARE | AS | ASC | ASSERTION |
| AT | AUTHORIZATION | AVG | BEGIN |
| BETWEEN | BIGINT | BINARY | BIT |
| BIT_LENGTH | BY | CASCADE | CASCADED |
| CASE | CAST | CATALOG | CHAR |
| CHAR_LENGTH | CHARACTER | CHARACTER_LENGTH | CHECK |
| CLOSE | COALESCE | COBOL | COLLATE |
| COLLATION | COLUMN | COMMIT | CONNECT |
| CONNECTION | CONSTRAINT | CONSTRAINTS | CONTINUE |
| CONVERT | CORRESPONDING | COUNT | CREATE |
| CURRENT | CURRENT_DATE | CURRENT_TIME | CURRENT_TIMESTAMP |
| CURSOR | DATE | DAY | DEALLOCATE |
| DEC | DECIMAL | DECLARE | DEFERRABLE |
| DEFERRED | DELETE | DESC | DESCRIBE |
| DESCRIPTOR | DIAGNOSTICS | DICTIONARY | DISCONNECT |
| DISPLACEMENT | DISTINCT | DOMAIN | DOUBLE |
| DROP | ELSE | END | END-EXEC |
| ESCAPE | EXCEPT | EXCEPTION | EXEC |
| EXECUTE | EXISTS | EXTERNAL | EXTRACT |
| FALSE | FETCH | FIRST | FLOAT |
| FOR | FOREIGN | FORTRAN | FOUND |
| FROM | FULL | GET | GLOBAL |
| GO | GOTO | GRANT | GROUP |
| HAVING | HOUR | IDENTITY | IGNORE |
| IMMEDIATE | IN | INCLUDE | INDEX |
| INDICATOR | INITIALLY | INNER | INPUT |
| INSENSITIVE | INSERT | INTEGER | INTERSECT |
| INTERVAL | INTO | IS | ISOLATION |
| JOIN | KEY | LANGUAGE | LAST |
| LEFT | LEVEL | LIKE | LOCAL |
| LONGVARBINARY | LOWER | MATCH | MAX |
| MIN | MINUTE | MODULE | MONTH |
| MUMPS | NAMES | NATIONAL | NCHAR |
| NEXT | NONE | NOT | NULL |
| NULLIF | NUMERIC | OCTET_LENGTH | OF |
| OFF | ON | ONLY | OPEN |
| OPTION | OR | ORDER | OUTER |
| OUTPUT | OVERLAPS | PARTIAL | PASCAL |
| PLI | POSITION | PRECISION | PREPARE |
| PRESERVE | PRIMARY | PRIOR | PRIVILEGES |
| PROCEDURE | PUBLIC | REAL | REFERENCES |
| RESTRICT | REVOKE | RIGHT | ROLLBACK |
| ROWS | SCHEMA | SCROLL | SECOND |
| SECTION | SELECT | SEQUENCE | SET |
| SIZE | SMALLINT | SOME | SQL |
| SQLCA | SQLCODE | SQLERROR | SQLSTATE |
| SQLWARNING | SUBSTRING | SUM | SYSTEM |
| TABLE | TEMPORARY | THEN | TIME |
| TIMESTAMP | TIMEZONE_HOUR | TIMEZONE_MINUTE | TINYINT |
| TO | TRANSACTION | TRANSLATE | TRANSLATION |
| TRUE | UNION | UNIQUE | UNKNOWN |
| UPDATE | UPPER | USAGE | USER |
| USING | VALUE | VALUES | VARBINARY |
| VARCHAR | VARYING | VIEW | WHEN |
| WHENEVER | WHERE | WITH | WORK |
| YEAR |