====== TRUNCATE TABLE Statement ======

TRUNCATE TABLE statement removes all rows in the specified table.

**Syntax**:

<code language=sql>
TRUNCATE [TABLE] table_name 
</code>

**Example:**

Remove all rows in //users2015// table:

<code language=sql>
truncate table users2015;
</code>

**Compatibility:** Oracle, Microsoft SQL Server, IBM DB2, MySQL, Hive

**Version**: HPL/SQL 0.3.17

See also:
  * [[drop-table|DROP TABLE]]