+ 1
Whats the difference between drop and delete?
6 Antworten
+ 8
drop modifies schema: e.g. deletes a table from DB
delete modifies data: e.g. removes row(s) from table
+ 2
drop deletes whole i.e whole column,table from database whereas
in delete u can delete stuff of ur choice 
+ 1
delete removes data from its container (tables or databases), whereas drop removes the containers themselves
+ 1
By using DROP command,  table is deleted. 
By using DELETE command,  contents in the table is deleted but not the table, the table still exists. 
+ 1
delete -remove particular row or record in the table
drop -  remove a table from database (all the table rows and column names (indexes))
truncate - remove all rows from table 
0
delete:- use to remove more than one row while
drop:- use remove complete table,
truncate:- delete+free up occupied spaces.



