What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
- 9 Answers
- 17333 Views
- I also Faced
- E-Mail Answers
Answer Posted / baijnath tiwari
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 ? | 1 Yes | 2 No |
Post New Answer View All Answers
What happens when converting big values to integers?
How to create an index on a view?
How many types of functions are there in sql server?
how would you improve etl (extract, transform, load) throughput?
What are the rendering extensions of ssrs?
Explain what are various ways to enhance the ssrs report?
What is a cube? : sql server analysis services, ssas
Explain about thread and memory management process of SQL?
What is the sql server 2000 version number?
What are rows and columns?
What is difference between foreign key and unique key?
What is the name of reporting services config file and what’s it’s used for?
What is identity?
What is clustered vs nonclustered index?
How to generate random numbers with the rand() function in ms sql server?
