what is the difference between Delete and Truncate
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 do you mean by data manipulation language?
How many triggers are possible per table?
What is triggers and stored procedures?
What are the properties and different types of sub-queries?
Mention the differences between having and where clause.
Where do we use trace frag?
How to connect ms access to sql servers through odbc?
How raid can influence database performance?
Relational calculus is what type of language?
Explain data warehousing in sql server?
How except clause is differs from not in clause?
What is rank function?
What guidelines should be followed to help minimize deadlocks?
How do indexes help, types?
what happens on checkpoint? : Sql server database administration