SQL TRUNCATE TABLE

.

SQL TRUNCATE TABLE Query 

In Sql truncate Command is used to remove the all data from data base but the structure of the table remains same

If you Want to remove the data from existing table without Remoing it structure the use the Truncate Query in Sql

Truncate table Syntax-

SQL> TRUNCATE TABLE  table_name; 

Truncate table Example-

SQL> TRUNCATE TABLE  Student; 

In above TRUNCATE TABLE  Example It Will Remove the all the data from Student table but the Structure of Student Will Remains Same.

.