Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between Delete and Truncate
- 4 Answers
- 8854 Views
- CarrizalSoft Technologies, Geo Research Centre, I also Faced
- E-Mail Answers
Answer Posted / anil sharma
Delete command execute row by row and it can't reset any
identity column's value.
But using Truncate command it reset all table and Identity
column also.So truncate command is fast then delete command.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is use of except clause?
What is difference between group by and having?
How to delete exactly duplicate records from a table?
What is de-normalization and what are some of the examples of it?
What do you mean by sql server agent?
Why transaction is important?
What is report subscription?
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
What is the maximum rows in sql server table?
What are the different types of backups that exist?
Where is trigger in sql server?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
What does normalization do to data?
How to get a list all databases on the sql server?
How do you manipulate data?
