SQL Truncate Table
Using this statement you can remove all data of rows or column ( complete data ) not table. In this there is no where clause but where clause is available in Delete statement. Truncate table is faster than Delete statement
Note -> Drop table query remove the entire structure of a table as well as entire data inside the table but in truncate we can remove the data only not table structure .
Syntax ->
Truncate table tablenName ;
Example ->
Suppose i have a table , name is student and i want to remove the date of student table then we can do like this below ->
Truncate table student ;
0 Comment(s)