MSQUERY: Reserved Keywords in MS Query

ID: Q125948

The information in this article applies to:

Microsoft Query for Windows, version 1.0
Microsoft Query for Windows 95, version 2.0
Microsoft Query for the Macintosh, version 1.0

SUMMARY

The following keywords are reserved for use in Open Database Connectivity (ODBC) function calls. When you use these keywords to name a table or database you may receive unexpected results or cause Microsoft Query to generate the following error message:

   Syntax Error in From Clause

Using these Keywords as field names may also produce unexpected results. Their use as field names is not supported. In addition to the keywords listed below, the individual ODBC drivers might include additional keywords. Check your driver documentation for complete listings of reserved words.

Keywords

   ABSOLUTE
   ADA
   ADD
   ALL
   ALLOCATE
   ALTER
   AND
   ANY
   ARE
   AS
   ASC
   ASSERTION
   AT
   AUTHORIZATION
   AVG
   BEGIN
   BETWEEN
   BIT
   BIT_LENGTH
   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
   CURRENT
   CURRENT_DATE
   CURRENT-TIME
   CURRENT_TIMESTAMP
   CURSOR
   DATABASE
   DATE
   DAY
   DEALLOCATE
   DEC
   DECIMAL
   DECLARE
   DEFERRABLE
   DEFERRED
   DELETE
   DESC
   DESCRIBE
   DESCRIPTOR
   DIAGNOSTICS
   DICTIONARY
   DISCONNECT
   DISPLACEMENT
   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
   GENERAL
   GET
   GLOBAL
   GO
   GOTO
   GRANT
   GROUP
   HAVING
   HOUR
   IDENTITY
   IGNORE
   IMMEDIATE
   IN
   INCLUDE
   INDEX
   INDICATOR
   INITIALLY
   INNER
   INPUT
   INSENSITIVE
   INSERT
   INTEGER
   INTERSECT
   INTERVAL
   INTO
   IS
   ISOLATION
   JOIN
   KEY
   LANGUAGE
   LAST
   LEFT
   LEVEL
   LIKE
   LOCAL
   LOWER
   MATCH
   MAX
   MIN
   MINUTE
   MODULE
   MONTH
   MUMPS
   NAMES
   NATIONAL
   NCHAR
   NEXT
   NONE
   NOT
   NULL
   NULLIF
   NUMERIC
   OCTET_LENGTH
   OF
   OFF
   ON
   ONLY
   OPEN
   OIPTION
   OR
   ORDER
   OUTER
   OUTPUT
   OVERLAPS
   PARTIAL
   PASCAL
   PLI
   POSITION
   PRECISION
   PREPARE
   PRESERVE
   PRIMARY
   PRIOR
   PRIVILEGES
   PROCEDURE
   PUBLIC
   RESTRICT
   REVOKE
   RIGHT
   ROLLBACK
   ROWS
   SCHEMA
   SCROLL
   SECOND
   SECTION
   SELECT
   SEQUENCE
   SET
   SIZE
   SMALLINT
   SOME
   SQL
   SQLCA
   SQLCODE
   SQLERROR
   SQLSTATE
   SQLWARNING
   SUBSTRING
   SUM
   SYSTEM
   TABLE
   TEMPORARY
   THEN
   TIME
   TIMESTAMP
   TIMEZONE_HOUR
   TIMEZONE_MINUTE
   TO
   TRANSACTION
   TRANSLATE
   TRANSLATION
   TRUE
   UNION
   UNIQUE
   UNKNOWN
   UPDATE
   UPPER
   USAGE
   USER
   USING
   VALUE
   VALUES
   VARCHAR
   VARYING
   VIEW
   WHEN
   WHENEVER
   WHERE
   WITH
   WORK
   YEAR

REFERENCES

Microsoft 2.0 ODBC Programmer's Reference

Additional query words: 1.00 2.00 key words

Keywords          : kb3rdparty kbtshoot
Version           : WINDOWS:1.0,2.0; MACINTOSH:1.0
Platform          : MACINTOSH WINDOWS

Last Reviewed: February 4, 1998