How to Truncate Table in SQL



Truncate Table command allows us to delete all the data in the table without deleting the table itself. This command does not delete the entire table, but it only deletes the records inside the table.
In this tutorial we will learn to truncate a table in SQL.

Step 1- Viewing Table Data
First of all let us view the records from any table, let it be dummy in our case.
For that write:
Select * from dummy
and execute it by pressing F5.

Dummy Table Data

Step 2- Executing Command
Now write the Truncate Table command along with the required table name.
The query would be:
Truncate table dummy
and execute it .

Truncate Query

Step 3- Data Removed
Now view the records of dummy table again, you will observe that the table would be empty with no records present.
That is what the Truncate Table query does.
Data Deleted

And that is how we can truncate a table in SQL.