SQL Grammar Support
The ODBC v2.5 specification provides three levels of SQL grammar support: Minimum, Core, and Extended. Each higher level provides more fully-implemented data definition and data manipulation language support. The relational interface fully supports the minimum SQL grammar, as well as many core and extended grammar statements. The relational interface support for SQL grammar is summarized in the following table.
Table 26
SQL Grammar Support
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. If an identifier is a keyword, it must delimited.
The delimiter character for identifiers is the double-quote.
Examples
SELECT "last-name" FROM "non-standard-tbl"
The hyphen is a non-ODBC standard character.
SELECT "password" FROM my_pword_tbl
“Password” is a keyword in the SET PASSWORD statement.