I am confused between drop and delete. Someone please explain.

Answer 1

Drop is to delete whole table or column. delete is to delete a record or set of records

Answer 2

Delete can only delete data in a table, but drop can delete a table, column, and the whole database. Think of delete as a jack hammer that can remove small pieces of a road and drop as a bull dozer that can take out large portions of road at a time.

Answer 3

Drop deletes both data and structure of the table.
Delete deletes only data not the table structure/definition. We can use where clause also to delete data using delete command.

Answer 4

Delete removes only selected data while drop removes all data

Answer 5

drop command is use to delete whole table but delete command with is used to delete the selected rows only

Answer 6

Drop will remove the specified column/table with no chance of rollback,
whereas delete will remove data from a table but nor the table structure, and can use rollback

Answer 7

these answers are absolutely currect