SQL (Structured Query Language) Question:
What is the difference between TRUNCATE and DELETE commands?
Answer:
TRUNCATE is a DDL command whereas DELETE is a DML command. Hence DELETE operation can be rolled back, but TRUNCATE operation cannot be rolled back. WHERE clause can be used with DELETE and not with TRUNCATE.
| Previous Question | Next Question |
| Which system tables contain information on privileges granted and privileges obtained? | State true or false. EXISTS, SOME, ANY are operators in SQL? |