What is Difference between drop and delete in SQL? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 1

What is Difference between drop and delete in SQL?

drop and delete

31st Dec 2016, 9:06 AM
Manish
Manish - avatar
4 Answers
+ 3
drop is a ddl(data definition language)operation while delete is a dml(data manipulation language)operation. Drop deletes the table or schema from database. Delete removes the rows from the table usually according to a where clause but not necessarily, still the schema exists for that table.
1st Jan 2017, 6:14 PM
arif abbas
arif abbas - avatar
+ 3
Drop removes tha table from the database while delete only removes the data from table
1st Jan 2017, 2:53 PM
gunjan maheshwari
gunjan maheshwari - avatar
+ 2
Drop is used for deleting objects like table or database. Delete is used for deleting data from a table.
31st Dec 2016, 9:10 AM
Uran Kajtazaj
Uran Kajtazaj - avatar
+ 2
thanks buddy #uran
31st Dec 2016, 9:11 AM
Manish
Manish - avatar