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>
|
11 March 2018

Differentiate between 'delete' arid 'drop'
You May Also Like
- Database Management System
Relational Algebra 2Mar 15, 2018
- Database Management System
Relational Algebra for Banking enterpriseMar 15, 2018
- Database Management System
- Database Management System
Differentiate between 'delete' arid 'drop'Mar 11, 2018
Labels:
Database Management System
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment