Difference b/w DELETE and DROP command? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

Difference b/w DELETE and DROP command?

Is DELETE removes only the data of the table permanently but DROP removes the whole table?

7th Mar 2018, 9:04 AM
Zeeshan zakaria
Zeeshan zakaria - avatar
3 Answers
+ 12
delete removes only data stored in the table , but drop delete data available as well as the structure of the table //the structure of table remain there when U use delete command as it is used to delete recirds of the table
7th Mar 2018, 1:14 PM
Gaurav Agrawal
Gaurav Agrawal - avatar
+ 5
Yes, DELETE removes all of the data in a table permanently while DROP permanently deletes specific parts of the table or the whole table which depends on you. So you can delete a column and all of the data in that column with DROP while DELETE just removes all the data in the table. I haven't gotten this far into SQL but I read the lesson about it before answering your question. If I did something wrong, please correct it immediately
7th Mar 2018, 9:21 AM
luʁi
+ 1
DELETE as you said just removes data from your tables, while the DROP command is used to remove columns or entire tables.
7th Mar 2018, 9:21 AM
Sir Drake
Sir Drake - avatar