Reserved word list
- Last UpdatedJun 17, 2024
- 2 minute read
This section lists keywords that are excluded from use with the SQL Access Bind List, the Table Template, and the ODBC interface.
If a reserved keyword is used as the Column Name in a Bind List or Table Template, an error message appears in the Log Viewer. The type of error depends upon the ODBC driver being used and the location where the keyword is found. For example, one of the most common errors is using DATE and TIME for Column Names in a Bind List or Table Template. To avoid this error, use a slightly different name, for example, "aDATE" and "aTIME".
Reserved keywords define the Structured Query Language (SQL) used by InTouch SQL Access. The keywords are also recognized by the specific ODBC driver being used. If the SQL command cannot be interpreted correctly, SQL Access Manager generates an error message that can be viewed from the Log Viewer.
The following alphabetical list shows the reserved keywords for SQL Access and ODBC:
|
ABSOLUTE |
ADA |
ADD |
|
ALL |
ALLOCATE |
ALTER |
|
AND |
ANY |
ARE |
|
AS |
ASC |
ASSERTION |
|
AT |
AUTHORIZATION |
AVG |
|
BEGIN |
BETWEEN |
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 |
|
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 |
INTERVALL |
|
INTO |
IS |
ISOLATION |
|
JOIN |
KEY |
LANGUAGE |
|
LAST |
LEFT |
LEVEL |
|
LIKE |
LOCAL |
LOWER |
|
MATCH |
MAX |
MIN |
|
MINUTE |
MODULE |
MONTH |
|
MUMPS |
NAMES |
NATIONAL |
|
NCHAR |
NEXT |
NONE |
|
NOT |
NULL |
NULLIF |
|
NUMERIC |
OCTET_LENGTH |
OF |
|
OFF |
ON |
ONLY |
|
OPEN |
OPRN |
OPTION |
|
OR |
ORDER |
OUTER |
|
OUTPUT |
OVERLAPS |
PARTIAL |
|
PASCAL |
PLI |
POSITION |
|
PRECISION |
PREPARE |
PRESERVE |
|
PRIMARY |
PRIOR |
PRIVILEGES |
|
PROCEDURE |
PUBLIC |
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_MINU |
|
TO |
TRANSACTION |
TRANSLATE |
|
TRANSLATION |
TRUE |
UNION |
|
UNIQUE |
UNKNOWN |
UPDATE |
|
UPPER |
USAGE |
USING |
|
VALUE |
VALUES |
VARCHAR |
|
VARING |
VIEW |
WHEN |
|
WHENEVER |
WHERE |
WITH |
|
WORK |
YEAR |