|
|
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 |
|
|