Subject: reserved words To: larson@vms.tarleton.edu Collection of reserved words for QUERY and JET ************************** Query Reserved words ************************** a ABSOLUTE ADA ADD ALL ALLOCATE ALTER AND ANY ARE AS ASC ASSERTION AT AUTHORIZATION AVG b BEGIN BETWEEN BIT BIT_LENGTH BY c 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 d DATABASE DATE DAY DEALLOCATE DEC DECIMAL DECLARE DEFERRABLE DEFERRED DELETE DESC DESCRIBE DESCRIPTOR DIAGNOSTICS DICTIONARY DISCONNECT DISPLACEMENT DISTINCT DOMAIN DOUBLE DROP e ELSE END END-EXEC ESCAPE EXCEPT EXCEPTION EXEC EXECUTE EXISTS EXTERNAL EXTRACT f FALSE FETCH FIRST FLOAT FOR FOREIGN FORTRAN FOUND FROM FULL g GENERAL GET GLOBAL GO GOTO GRANT GROUP h HAVING HOUR i IDENTITY IGNORE IMMEDIATE IN INCLUDE INDEX INDICATOR INITIALLY INNER INPUT INSENSITIVE INSERT INTEGER INTERSECT INTERVAL INTO IS ISOLATION j JOIN k KEY l LANGUAGE LAST LEFT LEVEL LIKE LOCAL LOWER m MATCH MAX MIN MINUTE MODULE MONTH MUMPS n NAMES NATIONAL NCHAR NEXT NONE NOT NULL NULLIF NUMERIC o OCTET_LENGTH OF OFF ON ONLY OPEN OIPTION OR ORDER OUTER OUTPUT OVERLAPS q p PARTIAL PASCAL PLI POSITION PRECISION PREPARE PRESERVE PRIMARY PRIOR PRIVILEGES PROCEDURE PUBLIC r RESTRICT REVOKE RIGHT ROLLBACK ROWS s SCHEMA SCROLL SECOND SECTION SELECT SEQUENCE SET SIZE SMALLINT SOME SQL SQLCA SQLCODE SQLERROR SQLSTATE SQLWARNING SUBSTRING SUM SYSTEM t TABLE TEMPORARY THEN TIME TIMESTAMP TIMEZONE_HOUR TIMEZONE_MINUTE TO TRANSACTION TRANSLATE TRANSLATION TRUE u UNION UNIQUE UNKNOWN UPDATE UPPER USAGE USER USING v VALUE VALUES VARCHAR VARYING VIEW w WHEN WHENEVER WHERE WITH WORK y YEAR z ************************** MS Jet Reserved words ************************** Reserved Words A ABSOLUTE ACTION ADD ADMINDB ALL ALLOCATE ALPHANUMERIC ALTER AND ANY ARE AS ASC ASSERTION AT AUTHORIZATION AUTOINCREMENT AVG B BAND BEGIN BETWEEN BINARY BIT BIT_LENGTH BNOT BOR BOTH BXOR BY BYTE C CASCADE CASCADED CASE CAST CATALOG CHAR CHARACTER CHAR_LENGTH CHARACTER_LENGTH CHECK CLOSE COALESCE COLLATE COLLATION COLUMN COMMIT COMP COMPRESSION CONNECT CONNECTION CONSTRAINT CONSTRAINTS CONTAINER CONTINUE CONVERT CORRESPONDING COUNT COUNTER CREATE CREATEDB CROSS CURRENCY CURRENT CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP CURRENT_USER CURSOR D DATABASE DATE DATETIME DAY DEALLOCATE DEC DECIMAL DECLARE DEFAULT DEFERRABLE DEFERRED DELETE DESC DESCRIBE DESCRIPTOR DIAGNOSTICS DISALLOW DISCONNECT DISTINCT DOMAIN DOUBLE DROP E ELSE END END-EXEC ESCAPE EXCEPT EXCEPTION EXCLUSIVECONNECT EXEC EXECUTE EXISTS EXTERNAL EXTRACT F FALSE FETCH FIRST FLOAT FLOAT4 FLOAT8 FOR FOREIGN FOUND FROM FULL G GENERAL GET GLOBAL GO GOTO GRANT GROUP GUID H HAVING HOUR I IDENTITY IEEEDOUBLE IEEESINGLE IGNORE IMAGE IMMEDIATE IN INDEX INDICATOR INHERITABLE INITIALLY INNER INPUT INSENSITIVE INSERT INT INTEGER INTEGER1 INTEGER2 INTEGER4 INTERSECT INTERVAL INTO IS ISOLATION J JOIN K KEY L LANGUAGE LAST LEADING LEFT LEVEL LIKE LOCAL LOGICAL LOGICAL1 LONG LONGBINARY LONGCHAR LONGTEXT LOWER M MATCH MAX MEMO MIN MINUTE MODULE MONEY MONTH N NAMES NATIONAL NATURAL NCHAR NEXT NO NOT NOTE NULL NULLIF NUMBER NUMERIC O OBJECT OCTET_LENGTH OF OLEOBJECT ON ONLY OPEN OPTION OR ORDER OUTER OUTPUT OVERLAPS OWNERACCESS P PAD PARAMETERS PARTIAL PASSWORD PERCENT PIVOT POSITION PRECISION PREPARE PRESERVE PRIMARY PRIOR PRIVILEGES PROC PROCEDURE PUBLIC Q R READ REAL REFERENCES RELATIVE RESTRICT REVOKE RIGHT ROLLBACK ROWS S SCHEMA SCROLL SECOND SECTION SELECT SELECTSCHEMA SELECTSECURITY SESSION SESSION_USER SET SHORT SINGLE SIZE SMALLINT SOME SPACE SQL SQLCODE SQLERROR SQLSTATE STRING SUBSTRING SUM SYSTEM_USER T TABLE TABLEID TEMPORARY TEXT THEN TIME TIMESTAMP TIMEZONE_HOUR TIMEZONE_MINUTE TO TOP TRAILING TRANSACTION TRANSFORM TRANSLATE TRANSLATION TRIM TRUE U UNION UNIQUE UNIQUEIDENTIFIER UNKNOWN UPDATE UPDATEIDENTITY UPDATEOWNER UPDATESECURITY UPPER USAGE USER USING V VALUE VALUES VARBINARY VARCHAR VARYING VIEW W WHEN WHENEVER WHERE WITH WORK WRITE X Y YEAR YESNO Z ZONE