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 - HPL/SQL

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: