Updated on 2022-12-14 GMT+08:00

TRUNCATE TABLE

Function

This command is used to clear all data in a specific table.

Syntax

TRUNCATE TABLE tableIdentifier

Parameter Description

Table 1 Parameters

Parameter

Description

tableIdentifier

Table name.

Examples

truncate table h0_1;

System Response

Data in the table is cleared. You can run the QUERY statement to check whether data in the table has been deleted.