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, make sure that you are granted the required permissions to execute DROP statements.