10	SQL Statements and Extensions for the Salesforce Driver

The Salesforce driver provides support for standard SQL (primarily SQL 92). In addition, the product supports a set of SQL extensions. For example, the product supports extensions that allow you to change the default schema or set the maximum number of Web service calls the driver can make when executing a SQL statement.

This chapter describes both the standard SQL statements and the SQL extensions. Table 10-1 lists the SQL statements and extensions supported by the Salesforce driver in alphabetical order. The extensions are denoted by (EXT).

Table 10-1. Supported SQL Statements and Extensions

■ Alter Cache (EXT)	■ Create Table	■ Explain Plan
■ Alter Index	■ Create View	■ Insert
■ Alter Sequence	■ Delete	■ Refresh Cache (EXT)
■ Alter Session (EXT)	■ Drop Cache (EXT)	■ Refresh Schema (EXT)
■ Alter Table	■ Drop Index	■ Select
■ Checkpoint	■ Drop Sequence	■ Set Checkpoint Defrag
■ Create Cache (EXT)	■ Drop Table	■ Set Logsize
■ Create Index	■ Drop View	■ Update
■ Create Sequence