+ 1

Whats the difference between drop and delete?

24th Sep 2016, 3:03 PM
Roxana Ivan
Roxana Ivan - avatar
6 Réponses
+ 8
drop modifies schema: e.g. deletes a table from DB delete modifies data: e.g. removes row(s) from table
24th Sep 2016, 4:13 PM
David Tonoyan
David Tonoyan - avatar
+ 2
drop deletes whole i.e whole column,table from database whereas in delete u can delete stuff of ur choice
25th Sep 2016, 7:49 AM
Kashish Sharma
Kashish Sharma - avatar
+ 1
delete removes data from its container (tables or databases), whereas drop removes the containers themselves
28th Sep 2016, 4:19 AM
Andrés Quintero
Andrés Quintero - avatar
+ 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.
4th Oct 2016, 6:43 AM
Bishal Tamang
Bishal Tamang - avatar
+ 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
14th Oct 2016, 6:34 AM
sabarmathi
0
delete:- use to remove more than one row while drop:- use remove complete table, truncate:- delete+free up occupied spaces.
25th Sep 2016, 6:48 PM
Shivank Singh Parihad
Shivank Singh Parihad - avatar