|
List of SQL Key Words |
|
|
The following list of SQL key words should be checked to make sure that none of the fields in your files have the same name as a SQL key word. If so, then the field name must be changed before you can successfully access that file via the ODBC drivers.
|
|
ABSOLUTE |
ACTION |
ADA |
|
ADD |
ALL |
ALLOCATE |
|
ALTER |
AND |
ANY |
|
ARE |
AS |
ASC |
|
ASSERTION |
AT |
AUTHORIZATION |
|
AVG |
BEGIN |
BETWEEN |
|
BIT |
BIT_LENGTH |
BOTH |
|
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 |
|
CROSS |
CURRENT |
CURRENT_DATE |
|
CURRENT_TIME |
CURRENT_TIMESTAMP |
CURRENT_USER |
|
CURSOR |
DATE |
DAY |
|
DEALLOCATE |
DEC |
DECIMAL |
|
DECLARE |
DEFAULT |
DEFERRABLE |
|
DEFERRED |
DELETE |
DESC |
|
DESCRIBE |
DESCRIPTOR |
DIAGNOSTICS |
|
DISCONNECT |
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 |
IMMEDIATE |
|
IN |
INCLUDE |
INDEX |
|
INDICATOR |
INITIALLY |
INNER |
|
INPUT |
INSENSITIVE |
INSERT |
|
INTEGER |
INTERSECT |
INTERVAL |
|
INTO |
IS |
ISOLATION |
|
JOIN |
KEY |
LANGUAGE |
|
LAST |
LEADING |
LEFT |
|
LEVEL |
LIKE |
LOCAL |
|
LOWER |
MATCH |
MAX |
|
MIN |
MINUTE |
MODULE |
|
MONTH |
MUMPS |
NAMES |
|
NATIONAL |
NATURAL |
NCHAR |
|
NEXT |
NO |
NONE |
|
NOT |
NULL |
NULLIF |
|
NUMERIC |
OCTET_LENGTH |
OF |
|
ON |
ONLY |
OPEN |
|
OPTION |
OR |
ORDER |
|
OUTER |
OUTPUT |
OVERLAPS |
|
PAD |
PARTIAL |
PASCAL |
|
PLI |
POSITION |
PRECISION |
|
PREPARE |
PRESERVE |
PRIMARY |
|
PRIOR |
PRIVILEGES |
PROCEDURE |
|
PUBLIC |
REFERENCES |
RELATIVE |
|
RESTRICT |
REVOKE |
RIGHT |
|
ROLLBACK |
ROWS |
SCHEMA |
|
SCROLL |
SECOND |
SECTION |
|
SELECT |
SEQUENCE |
SESSION |
|
SESSION_USER |
SET |
SIZE |
|
SMALLINT |
SOME |
SPACE |
|
SQL |
SQLCA |
SQLCODE |
|
SQLERROR |
SQLSTATE |
SQLWARNING |
|
SUBSTRING |
SUM |
SYSTEM_USER |
|
TABLE |
TEMPORARY |
THEN |
|
TIME |
TIMESTAMP |
TIMEZONE_HOUR |
|
TIMEZONE_MINUTE |
TO |
TRAILING |
|
TRANSACTION |
TRANSLATE |
TRANSLATION |
|
TRIM |
TRUE |
UNION |
|
UNIQUE |
UNKNOWN |
UPDATE |
|
UPPER |
USAGE |
USER |
|
USING |
VALUE |
VALUES |
|
VARCHAR |
VARYING |
VIEW |
|
WHEN |
WHENEVER |
WHERE |
|
WITH |
WORK |
YEAR |