+ 2

delete can also be used in place of drop. Then what's the difference between them?

I have used delete in place of drop and it works.

16th Jul 2016, 8:21 PM
Anand Kishore
Anand Kishore - avatar
2 Réponses
+ 4
drop is used to remove the schema of your database while delete is used for deleting the records
17th Jul 2016, 4:44 AM
parthsarathi ajmani
parthsarathi ajmani - avatar
+ 3
Delete is conditional & removes rows. Drop will delete the entire table & it's structure.
17th Jul 2016, 1:32 AM
Justin McKay
Justin McKay - avatar