|
|
While not being within the mandated SQL core, these keywords should be avoided in applications to preserve compatibility with SQL99-compliant drivers.
ODBC 3.0 reserved keywords:
ABSOLUTE | BOTH | CONSTRAINT |
ACTION | BY | CONSTRAINTS |
ADA | CASCADE | CONTINUE |
ADD | CASCADED | CONVERT |
ALL | CASE | CORRESPONDING |
ALLOCATE | CAST | COUNT |
ALTER | CATALOG | CREATE |
AND | CHAR | CROSS |
ANY | CHAR_LENGTH | CURRENT |
ARE | CHARACTER | CURRENT_DATE |
AS | CHARACTER_LENGTH | CURRENT_TIME |
ASC | CHECK | CURRENT_TIMESTAMP |
ASSERTION | CLOSE | CURRENT_USER |
AT | COALESCE | CURSOR |
AUTHORIZATION | COLLATE | DATE |
AVG | COLLATION | DAY |
BEGIN | COLUMN | DEALLOCATE |
BETWEEN | COMMIT | DEC |
BIT | CONNECT | DECIMAL |
BIT_LENGTH | CONNECTION | DECLARE |
DEFAULT | FOUND | LANGUAGE |
DEFERRABLE | FROM | LAST |
DEFERRED | FULL | LEADING |
DELETE | GET | LEFT |
DESC | GLOBAL | LEVEL |
DESCRIBE | GO | LIKE |
DESCRIPTOR | GOTO | LOCAL |
DIAGNOSTICS | GRANT | LOWER |
DISCONNECT | GROUP | MATCH |
DISTINCT | HAVING | MAX |
DOMAIN | HOUR | MIN |
DOUBLE | IDENTITY | MINUTE |
DROP | IMMEDIATE | MODULE |
ELSE | IN | MONTH |
END | INCLUDE | NAMES |
END-EXEC | INDEX | NATIONAL |
ESCAPE | INDICATOR | NATURAL |
EXCEPT | INITIALLY | NCHAR |
EXCEPTION | INNER | NEXT |
EXEC | INPUT | NO |
EXECUTE | INSENSITIVE | NONE |
EXISTS | INSERT | NOT |
EXTERNAL | INT | NULL |
EXTRACT | INTEGER | NULLIF |
FALSE | INTERSECT | NUMERIC |
FETCH | INTERVAL | OCTET_LENGTH |
FIRST | INTO | OF |
FLOAT | IS | ON |
FOR | ISOLATION | ONLY |
FOREIGN | JOIN | OPEN |
FORTRAN | KEY | OPTION |
OR | SECOND | TRANSACTION |
ORDER | SECTION | TRANSLATE |
OUTER | SELECT | TRANSLATION |
OUTPUT | SESSION | TRIM |
OVERLAPS | SESSION_USER | TRUE |
PAD | SET | UNION |
PARTIAL | SIZE | UNIQUE |
PASCAL | SMALLINT | UNKNOWN |
POSITION | SOME | UPDATE |
PRECISION | SPACE | UPPER |
PREPARE | SQL | USAGE |
PRESERVE | SQLCA | USER |
PRIMARY | SQLCODE | USING |
PRIOR | SQLERROR | VALUE |
PRIVILEGES | SQLSTATE | VALUES |
PROCEDURE | SQLWARNING | VARCHAR |
PUBLIC | SUBSTRING | VARYING |
READ | SUM | VIEW |
REAL | SYSTEM_USER | WHEN |
REFERENCES | TABLE | WHENEVER |
RELATIVE | TEMPORARY | WHERE |
RESTRICT | THEN | WITH |
REVOKE | TIME | WORK |
RIGHT | TIMESTAMP | WRITE |
ROLLBACK | TIMEZONE_HOUR | YEAR |
ROWS | TIMEZONE_MINUTE | ZONE |
SCHEMA | TO | |
SCROLL | TRAILING |
|
|