SQL Reserved Words
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 |