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