MDAC 2.5 SDK - ODBC Desktop Database Drivers

Additional Supported ODBC SQL Grammar

The ODBC drivers completely support the Minimum ODBC 2.5 grammar and the following clauses in the Core and Extended ODBC 2.5 grammar. Additional information may be displayed by jumping to the ALTER TABLE Statement, Correlation Names, and Procedure Invocation topics.

• Approximate numeric literal (Core)
  
  
• ALTER TABLE Statement (Core)
  
  
• Binary literals (Extended)
  
  
• BETWEEN Predicate (Core)
  
  
• Correlation Names (Core)
  
  
• EXISTS predicate (Core)
  
  
• IN (valuelist) (Core)
  
  
• Outer Joins (Extended)
  
  
• Procedure Invocation (Extended)
  
  
• CREATE INDEX Statement
  
  
• SELECT statement (Extended) (including GROUP BY, HAVING, and UNION clauses)
  
  
• Subqueries (SUBSELECTs) (Core)
  
  
• Date Arithmetic
  
  
• Date, Time, and Timestamp Literals
  
  
• DROP INDEX Statement
  
  
• Fixed-width Text File
  
  
• GROUP BY expression-list
  
  
• ORDER BY expression-list
  
  
• ORDER BY with GROUP BY
  
  
• Scalar Functions
  
  
• Table Names