6 SQL Statements

This chapter provides information about the SQL statements available in TimesTen.

SQL statements are generally considered to be either data manipulation language (DML) statements or data definition language (DDL) statements.

DML statements modify database objects. INSERT, UPDATE and DELETE are examples of DML statements. The SELECT statement retrieves data from one or more tables or views.

DDL statements modify the database schema. CREATE TABLE and DROP TABLE are examples of DDL statements.

In addition to an alphabetical listing of all statements, this chapter also contains:

• Summary of SQL Statements Supported in TimesTen

• Comments Within SQL Statements

• Optimizer Hints