SQL Grammar Conformance

The ODBC v2.5 specification provides three levels of SQL grammar conformance: Minimum, Core, and Extended. Each higher level provides more fully-implemented data definition and data manipulation language support. The Pervasive ODBC Engine Interface fully supports the minimum SQL grammar, as well as many core and extended grammar statements. The Pervasive ODBC Engine Interface support for SQL grammar is summarized in the following table.

Table 2-8 SQL Grammar Conformance
SQL Grammar Statement	Minimum	Core	Extended
ALTER TABLE
CREATE GROUP
CREATE INDEX
CREATE PROCEDURE
CREATE TABLE
CREATE TRIGGER
CREATE VIEW
DELETE (positional)
DELETE (searched)
DROP GROUP
DROP INDEX
DROP PROCEDURE
DROP TABLE
DROP TRIGGER
DROP VIEW
GRANT
INSERT
JOIN LEFT OUTER (Select)
REVOKE
SELECT (with into)
- approximate-numeric-literal
- between-predicate
- correlation-name
- date arithmetic
- date-literal
- exact-numeric-literal
- extended predicates
- in-predicate
- set-function
- time-literal
- timestamp-literal
Subqueries
UNION
SET SECURITY
UPDATE (positional)
UPDATE (searched)

Delimited Identifiers in SQL Statements

Column names and table names can occur as delimited identifiers if they contain non-ODBC standard characters. The delimiter character for delimited identifiers is a double-quote. For example:

SELECT "last-name" FROM "non-standard-tbl"