A clause is a statement that modifies results. Clauses are not required statements, but refine what and how data is displayed. The WHERE clause in a query is one example.

For more information and restrictions on these and other SQL statements, see your DBMS-specific SQL documentation. The following example grants UPDATE and INSERT authority to user TESTUSER on the ...

The SAS/ACCESS engine passes the SQL CREATE TABLE statement and its clauses to the DBMS, which executes the statement and creates the DBMS table. ... In the following example, the DB2 table TEMP is ...