SQL statements

The ODBC and JDBC client drivers provide support for the following SQL statements:

• SELECT statement

• DELETE statement

• INSERT statement

• UPDATE statement

• CREATE TABLE statement

• TRUNCATE TABLE statement

• ALTER TABLE statement

• CREATE INDEX statement

• DROP INDEX statement

The client drivers also support FileMaker data type mapping to ODBC SQL and JDBC SQL data types. See Claris FileMaker ODBC and JDBC Guide for data type conversions. For more information on constructing SQL queries, refer to a third-party book.

Note  The ODBC and JDBC client drivers do not support FileMaker Pro portals.