Advertisements
Advertisements
Question
Differentiate between the following statement:
DELETE and DROP
Distinguish Between
Advertisements
Solution
Delete
- DELETE Command, removes some or all tuples/records from a relation/table.
- DELETE is DML.
- Delete command can be rollbacked as it works on a data buffer.
Drop
- DROP Command, removes named elements of a schema like relations/table, constraints, or entire schema.
- DROP is DDL.
- Drop command can't be rollbacked as it works directly on data.
shaalaa.com
Performing Insert, Update, Delete Queries Using Cursor
Is there an error in this question or solution?
Chapter 9: Structured Query Language (SQL) - Exercise [Page 177]
