SQL -Structured Query Language - SQL Delete - Truncate Table Tutorial

To delete or remove all the records or data from the existing table. Then we can use a ' TRUNCATE TABLE ' statement.

Syntax-

The basic syntax of the TRUNCATE TABLE statement is given below –

TRUNCATE TABLE table_name;

For Example-

TRUNCATE TABLE regions;

Run Query

This statement will work similarly to a delete statement having no conditions. The only difference is that the delete statement will not free up space while the truncate will free up space.