All Products
Search

This Product

    PolarDB:TRUNCATE TABLE

    Document Center

    PolarDB:TRUNCATE TABLE

    Last Updated:Mar 28, 2026

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

    Syntax

    TRUNCATE [TABLE] tbl_name

    For the full syntax reference, see TRUNCATE TABLE statement.

    Prerequisites

    Before you run TRUNCATE TABLE, ensure that you have the DROP privilege.