SQL TRUNCATE Command : Introduction

• SQL TRUNCATE Command is a type of SQL DDL command and is used to delete the pre-existing tables from the databases.
• The difference between SQL DELETE and SQL TRUNCATE Command is, there is no room for deleting specific values/rows from the table with the help of TRUNCATE command. Only the whole table can be deleted and not the specific rows/values.

 

SQL TRUNCATE Command : Syntax

• The syntax for SQL TRUNCATE command can be depicted as :

SQL TRUNCATE Command : Syntax

SQL TRUNCATE Command : Example

• Consider the student_details and teacher_details table over which we need to perform TRUNCATE command.

Table : student_details


Table : teacher_details

Example-1 : We wish to delete the student_details table. It can be done by executing below query.

Query : TRUNCATE Table student_details;

Output : No table to display(As TRUNCATE table will delete the table).

Example-2 : We wish to delete the teacher_details table. It can be done by executing below query.

Query : TRUNCATE Table teacher_details;

Output : No table to display(As TRUNCATE table will delete the table).