SQL (Structured Query Language) Question:
What is difference between TRUNCATE & DELETE?
Answer:
TRUNCATE commits after deleting entire table i.e., cannot be rolled back. Database triggers do not fire on TRUNCATE
DELETE allows the filtered deletion. Deleted records can be rolled back or committed. Database triggers fire on DELETE.
DELETE allows the filtered deletion. Deleted records can be rolled back or committed. Database triggers fire on DELETE.
| Previous Question | Next Question |
| What is the parameter substitution symbol used with INSERT INTO command? | What is SQL sub-query? |