+ 1
Whats the difference between drop and delete?
6 Respuestas
+ 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.