Overview of Statements

A FedSQL statement is a series of items that can include keywords, identifiers, special characters, and operators. All FedSQL statements end with a semicolon.
There are three categories of statements:
data definition
statements that are used to create, modify, and delete tables and views.
data control
statements that are used to control transactions with the database.
data manipulation
statements that are used to add, update, and delete data.
SQL pass-through facility
statements that connect to a DBMS and enable you to send DBMS-specific SQL statements directly to the DBMS.