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.
0 Comments