What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
- 9 Answers
- 16401 Views
- I also Faced
- E-Mail Answers
Answer Posted / radh
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.
| Is This Answer Correct ? | 27 Yes | 1 No |
Post New Answer View All Answers
What are the parts of a function?
Explain different forms of normalization?
What is a bit datatype?
How do you create a clustered index?
What is a rollup clause?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
How to create an multi-statement table-valued function?
Explain the purpose of indexes?
What are distributed partitioned views?
What is a periodical index?
What is 1nf 2nf?
Tell me what is the significance of null value and why should we avoid permitting null values?
How to convert a numeric expression from one data type to another?
How would you use user_constraints table in DB?
Define tool Manage Statistics in SQL Server 2000 query ?
