Interested to Buy Any Domain ? << Click Here >> for more details...
What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
- 9 Answers
- 19370 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
Explain about Normalization?
What is the difference between varchar and varchar(max) datatypes?
Tell me what is the stuff and how does it differ from the replace function?
Tell me something about security and sql azure?
How is sql server used?
Explain tablesample?
What do you mean by an execution plan? Why is it used?
How to download and install microsoft .net framework version 2.0?
Do you know the cursor optimization tips?
How you can get the list of largest tables in a database?
What do you understand by user-defined function in the sql server?
What are the difficulties faced in cube development? : sql server analysis services, ssas
What happens if the update subquery returns no rows in ms sql server?
How to test a dml trigger in ms sql server?
what are the reporting service components in SSRS?
