1.1.1

TRUNCATE TABLE
Remove all content from a table and return it to its initial, empty state.
Syntax
TRUNCATE TABLE table-name
Description
To truncate a table, you must be the table's owner. You cannot use this command to truncate system tables.
Example
To truncate the "flights" table in the current schema:
TRUNCATE TABLE flights;
UPDATE
Update the value of one or more columns.
Syntax
{ UPDATE table-name [ [ AS ] correlation-name]
SET column-name =
value
[, column-name = value} ]*
[ WHERE Clause ]
}
Description
This form of the UPDATE statement is called a searched update. It updates the value of one or more columns
for all rows of the table for which the WHERE clause evaluates to TRUE. Specifying DEFAULT for the update
value sets the value of the column to the default defined for that table.
The UPDATE statement returns the number of rows that were updated.
Note: Updates on partitioning column and primary key column are not supported.
value
expression | DEFAULT
Statement Dependency System
A searched update statement depends on the table being updated, all of its conglomerates (units of storage such
as heaps or indexes), all of its constraints, and any other table named in the WHERE clause or SET expressions.
A CREATE or DROP INDEX statement or an ALTER TABLE statement for the target table of a prepared
searched update statement invalidates the prepared searched update statement.
A CREATE or DROP INDEX statement or an ALTER TABLE statement for the target table of a prepared
positioned update invalidates the prepared positioned update statement.
Dropping a synonym invalidates a prepared update statement if the latter statement uses the synonym.
531
SQL Language Reference