InterviewSolution
| 1. |
What Is The Difference Between Delete And Truncate Statements? |
|
Answer» 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. A WHERE clause is not permited. The operation cannot be rolled back and no triggers will be fired. As such, TRUCATE is faster and doesn't use as much undo space as a DELETE. 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. A WHERE clause is not permited. The operation cannot be rolled back and no triggers will be fired. As such, TRUCATE is faster and doesn't use as much undo space as a DELETE. |
|