What is the difference Delete and Drop ?

Categories >> Software >> Databases >> MySQL
Suggest New Category

Question Posted / basawaraj.b

6 Answers
9009 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is the difference Delete and Drop ?..

Answer / sunil kumar

Delete command deletes the data from the table.
Drop command destroy,drop columns,tables.

Is This Answer Correct ?

25 Yes

0 No

What is the difference Delete and Drop ?..

Answer / anubhav tiwari

1.DELETE COMMANDS: ONLY DELETE DATA FROM TABLE NOT THE
STRUCTURE OF THE TABLE.DATA CAN BE CALL BACK USING ROLL
BACK.

2.DROP COMMANDS DLETE TABLE AND STRUCTURE BOTH FROM THE
DATABASE ie.DATA CANT BE ROLL BACK OVER HERE.

Is This Answer Correct ?

21 Yes

0 No

What is the difference Delete and Drop ?..

Answer / lalit samant

Where clause can de used with delete .

You can use where clause with drop or truncate

Is This Answer Correct ?

2 Yes

0 No

What is the difference Delete and Drop ?..

Answer / senthil d

Delete Command - Options to Delete particular record using
where clause and to delete all records. Table structure
remains. But it slower in performance as we compared with
truncate command

Drop Command - Drops the entire table from data base

Is This Answer Correct ?

2 Yes

1 No

What is the difference Delete and Drop ?..

Answer / kasirajan

delete command deletes the table temporarily from the database. we can get it back using the keyword ROLLBACK.
but the drop keyword deletes the table permanently from the database,we cant able to get it back...

Is This Answer Correct ?

1 Yes

0 No

What is the difference Delete and Drop ?..

Answer / reddi prasad

THE MAIN DIFFERENCE BETWEEN DELETE AND DROP:

DELETE: ONCE WE DELETE ANY DATA FROM THE DATABASE WE CAN
EASILY RETURN BACK THE DATA BY USING ROLLBACK.

DROP: ONCE WE DELETE ANY DATA FROM THE DATABASE WE CAN'T EA
RETURN BACK THE DATA AND WE CAN SEE THE STRUCTURE OF OBJECT
ONLY.

Is This Answer Correct ?

9 Yes

15 No

Post New Answer