What is the difference between TRUNCATE & DROP commnad ? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 8

What is the difference between TRUNCATE & DROP commnad ?

18th Jan 2017, 4:08 AM
Jenny Lance
Jenny Lance - avatar
5 Answers
+ 5
I love practical examples: Truncate eats your salad (the actual data) and leaves the bowl (the table structure) on the counter (your database). DROP does what it says: the salad bowl is dropped! both the bowl and the salad are lost!
20th Jan 2017, 11:13 AM
Sadrak Souffrant
Sadrak Souffrant - avatar
+ 4
Truncate clears all data of the database table, Drop deletes the table from the database.
18th Jan 2017, 5:29 AM
seamiki
seamiki - avatar
+ 1
it is perfectly right answer
20th Jan 2017, 6:02 AM
santhyosh ag
+ 1
hii
20th Jan 2017, 6:16 AM
santhyosh ag
0
Rajkumar
29th Mar 2019, 2:34 PM
Bipin Kumar
Bipin Kumar - avatar