---

Oracle Truncate Table Statement

The Oracle TRUNCATE TABLE statement is used to remove all records from database table but keeps the structure of the table. The truncate table statement is similar to delete statement without a WHERE clause.

Oracle TRUNCATE TABLE Syntax

To remove all records from existing table, use the following syntax:

Parameters:

tablename: The table name from which you want to remove all records.

Oracle TRUNCATE TABLE example

The following Oracle statement to remove the content of the table:

Note:

In the above example, we have deleted the record for customer "Sunil Shetty".

---

---