Translate

Visit to www.mrmcse.com

11 March 2018

Differentiate between 'delete' arid 'drop'



Delete
Drop
(i) The DELETE command is used to remove rows from a table.
(i) The DROP command removes a table from the database.
(ii) Delete statement performs conditional based deletion.
(ii) Drop command deletes entire records in the table.
(iii) Delete is a DLM statement.
(iii) Drop is a DDL command.
(iv) Delete operation can be rolled back and it is not auto committed.
(iv) Drop operation cannot be rolled back in any way as it is an auto committed statement.
(v) They require segments in the UNDD table space.
(v) They do not require segments in the UNDO table space.
(vi) It can activate the triggers.
(vi) It does not activate the triggers.
(vii) The syntax for Delete statement:
DELETE FROM <table_name>
or,
DELETE FROM <table_name>
WHERE <condition>
(vii) The syntax for Drop command DROP TABLE <table_name>




No comments:

Post a Comment