what is the difference between delete,drop and truncate

Question Posted / mohammadali.info

2 Answers
5221 Views
Honeywell, Zomato, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is the difference between delete,drop and truncate..

Answer / mohammadali.info

*The DELETE command is used to remove rows from a table. A WHERE clause can be used to only remove some rows. If no WHERE condition is specified, all rows will be removed. After performing a DELETE operation you need to
COMMIT or ROLLBACK the transaction to make the change permanent or to undo it.

*TRUNCATE removes all rows from a table. The operation cannot be rolled back. As such, TRUCATE is faster and doesn't use as much undo space as a DELETE.

*The DROP command removes a table from the database. All the tables' rows,
indexes and privileges will also be removed. The operation cannot be rolled back.

*DROP and TRUNCATE are DDL commands, whereas DELETE is a DML command. Therefore DELETE operations can be rolled back (undone), while DROP and TRUNCATE operations cannot be rolled back.

IF Answer is Correct Pls give Rate

Is This Answer Correct ?

46 Yes

0 No

what is the difference between delete,drop and truncate..

Answer / krishna

DELETE,DROP,TRUNCTATE are to use the remove the rows from the table

DELETE: Delete is used to delete the rows from table by using where condition also and we can ROLLBACK it also

DROP: Delete rows permanently and we can not ROLLBACK it.

TRUNCATE : Delete the data not the structure means in this delete only data but structure is same

Is This Answer Correct ?

0 Yes

1 No

Post New Answer