User Tools

Site Tools


Sidebar

HPL/SQL is included to Apache Hive since version 2.0

truncate

This is an old revision of the document!


TRUNCATE TABLE Statement

TRUNCATE TABLE statement removes all rows in the specified table.

Syntax:

TRUNCATE [TABLE] table_name 

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: