0
Difference b/w DELETE and DROP command?
Is DELETE removes only the data of the table permanently but DROP removes the whole table?
3 Respostas
+ 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
+ 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
+ 1
DELETE as you said just removes data from your tables, while the DROP command is used to remove columns or entire tables.