All Products
Search
Document Center

TRUNCATE TABLE

Last Updated: Jul 31, 2020

This topic describes how to clear data from a table in Distributed Relational Database Service (DRDS) by executing the TRUNCATE TABLE statement. To execute this statement, you must have the permission for the DROP clause.

Syntax

  1. TRUNCATE [TABLE] tbl_name

For the detailed syntax, see MySQL TRUNCATE TABLE Statement.