TRUNCATE TABLE statement removes all rows in the specified table.

Syntax:

TRUNCATE [TABLE] table_name 

Example:

Remove all rows in users2015 table:

truncate table users2015;

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

Version: HPL/SQL 0.3.17

See also:

• DROP TABLE