Exact difference between DELETE, DROP and TRUNCATE in SQL.

Answer 1

Drop deletes the data and schema both. TRUNCATE erases the data only. Delete, anyone?

Answer 2

Drop: delete data and the table(schema)
Truncate: Removes all data from schema and reset identity column again if set in some column
delete: remove particular or all row from schema based on condition if any. but it does not reset the identity column.

Answer 3

delete delete the record where as drop not only delete record it also removes the physical structure of table truncate its used to cut the the data from particular limit