What is the differences between drop and delete in SQL?

Answer 1

Have a read :
https://www.sololearn.com/learn/SQL/1869/?ref=app
https://www.sololearn.com/learn/SQL/1872/?ref=app
Read the comments as well .All the Best ...

Answer 2

https://www.sololearn.com/discuss/1075839/?ref=app

Answer 3

T.Siva Kiran

Drop means parmanent deleted SQL object
And delete means clear selected data from table data or clear all table data

Answer 4

Tsadiku Mengste
Drop not remove data it delete objects like table, view , trigger, key etc

Answer 5

DELETE command and is used to remove tuples/records from a relation/table. Whereas DROPis used to remove named elements of schema like relations/table, constraints or entire schema.

Answer 6

clearly deleted data from a table

Answer 7

delete is removed only selected cell while drop removed the entire data