0
What's the difference between drop and delete?
2 Answers
+ 10
From Stackoverflow:
"DROPÂ will delete all data and the table structure as well.
DELETE will delete the data but the table structure will remain the same and we can still rollback the data. Also with DELETE you can use the where condition i.e. to delete only certain records."
+ 1
Delete: The DELETE command is used to remove rows from a table. A WHERE clause can be used to only remove some rows. If no WHERE condition is specified, all rows will be removed.
Drop: The DROP command removes a table from the database. All the tables' rows, indexes and privileges will also be removed.