What is difference between TRUNCATE and DELETE statement
Answer Posted / nageswarao
truncate is used for deleting all data from table.
it is similar to delete command without condition.
main differences b/w delete & truncate are
1.truncate is faster in execution than delete which will
restructure the complete table without bothering of data.
where as delete checks the data row by row wrotes
information into log and deletes.
2.with truncate we cannot use any conditions
Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
What is constraints and its types?
What is a field name?
What is @@error in sql?
How does index makes search faster?
How to remove duplicate rows from table except one?
how we use window authentication connection with sql server.?
What can be used instead of trigger?
what's the information that can be stored inside a bit column? : Sql server database administration
How do I start sql server?
Explain the rules for designing files and file groups in sql server?
How to identify current user in ssrs report?
How to find the source of a table in sql server?
What is self contained multi valued query?
what is the difference between openrowset and openquery?
How many clustered indexes there can be on table ?