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