TRUNCATE | DDL Command | TRUNCATE SQL

TRUNCATE Command

Truncate command used to delete data from table, but not the table structure.

This command may delete whole records from table.

We didn't rollback data. Because DDL commands are auto-committed that means it permanently save all the changes in the database.


Syntax :

TRUNCATE TABLE table_name;

Parameters

table_name = Name of table, which you want to truncate.

 Example :

// truncate Customer01 table
TRUNCATE TABLE Customre01;

* * * * * * * * * * * * * * * * *

In Easy Language

Truncate command used to delete data from table.