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.

Post a Comment

0 Comments