You can execute the TRUNCATE TABLE statement to clear data from a table.

Syntax

TRUNCATE [TABLE] tbl_name

For more information about the syntax, see TRUNCATE TABLE statement.

Note

Before you execute the TRUNCATE TABLE statement, ensure that you have the DROP permission.