VistaDB 6
VistaDB / Developer's Guide / SQL Reference / Reserved Keywords / ODBC Reserved Keywords
In This Topic
    ODBC Reserved Keywords
    In This Topic

    The following keywords are part of the ODBC driver specification. Please note that many of these overlap with the current SQL Server keywords. VistaDB does not currently include these in the reserved word list. It is considered a best practice to either avoid these words for compatibility with other database vendors, or to delimit them with brackets ([])or double quotes ("").

    ABSOLUTE
    ACTION
    ADA
    ADD
    ALL
    ALLOCATE
    ALTER
    AND
    ANY
    ARE
    AS
    ASC
    ASSERTION
    AT
    AUTHORIZATION
    AVG
    BEGIN
    BETWEEN
    BIT
    BIT_LENGTH
    BOTH
    BY
    CASCADE
    CASCADED
    CASE
    CAST
    CATALOG
    CHAR
    CHAR_LENGTH
    CHARACTER
    CHARACTER_LENGTH
    CHECK
    CLOSE
    COALESCE
    COLLATE
    COLLATION
    COLUMN
    COMMIT
    CONNECT
    CONNECTION
    CONSTRAINT
    CONSTRAINTS
    CONTINUE
    CONVERT
    CORRESPONDING
    COUNT
    CREATE
    CROSS
    CURRENT
    CURRENT_DATE
    CURRENT_TIME
    CURRENT_TIMESTAMP
    CURRENT_USER
    CURSOR
    DATE
    DAY
    DEALLOCATE
    DEC
    DECIMAL
    DECLARE
    DEFAULT
    DEFERRABLE
    DEFERRED
    DELETE
    DESC
    DESCRIBE
    DESCRIPTOR
    DIAGNOSTICS
    DISCONNECT
    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
    GET
    GLOBAL
    GO
    GOTO
    GRANT
    GROUP
    HAVING
    HOUR
    IDENTITY
    IMMEDIATE
    IN
    INCLUDE
    INDEX
    INDICATOR
    INITIALLY
    INNER
    INPUT
    INSENSITIVE
    INSERT
    INT
    INTEGER
    INTERSECT
    INTERVAL
    INTO
    IS
    ISOLATION
    JOIN
    KEY
    LANGUAGE
    LAST
    LEADING
    LEFT
    LEVEL
    LIKE
    LOCAL
    LOWER
    MATCH
    MAX
    MIN
    MINUTE
    MODULE
    MONTH
    NAMES
    NATIONAL
    NATURAL
    NCHAR
    NEXT
    NO
    NONE
    NOT
    NULL
    NULLIF
    NUMERIC
    OCTET_LENGTH
    OF
    ON
    ONLY
    OPEN
    OPTION
    OR
    ORDER
    OUTER
    OUTPUT
    OVERLAPS
    PAD
    PARTIAL
    PASCAL
    POSITION
    PRECISION
    PREPARE
    PRESERVE
    PRIMARY
    PRIOR
    PRIVILEGES
    PROCEDURE
    PUBLIC
    READ
    REAL
    REFERENCES
    RELATIVE
    RESTRICT
    REVOKE
    RIGHT
    ROLLBACK
    ROWS
    SCHEMA
    SCROLL
    SECOND
    SECTION
    SELECT
    SESSION
    SESSION_USER
    SET
    SIZE
    SMALLINT
    SOME
    SPACE
    SQL
    SQLCA
    SQLCODE
    SQLERROR
    SQLSTATE
    SQLWARNING
    SUBSTRING
    SUM
    SYSTEM_USER
    TABLE
    TEMPORARY
    THEN
    TIME
    TIMESTAMP
    TIMEZONE_HOUR
    TIMEZONE_MINUTE
    TO
    TRAILING
    TRANSACTION
    TRANSLATE
    TRANSLATION
    TRIM
    UNION
    UNIQUE
    UNKNOWN
    UPDATE
    UPPER
    USAGE
    USER
    USING
    TRUE
    VALUE
    VALUES
    VARCHAR
    VARYING
    VIEW
    WHEN
    WHENEVER
    WHERE
    WITH
    WORK
    WRITE
    YEAR
    ZONE

    See Also