+ 1
What is the difference between truncate and drop ?
3 odpowiedzi
+ 4
drop deletes the data and table reference truncate just deletes the data. After a truncate the table reference still remains.
+ 1
truncate doesn't delete the table structure where as drop deletes the table structure along with any triggers on them
0
truncate only delete the data in the table where as drop delets whole table that means all data with structures