What is difference between TRUNCATE and DELETE statement
- 12 Answers
- 20191 Views
- CTS, I also Faced
- E-Mail Answers
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 do you mean by a Composite primary key?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
How to create view in stored procedure sql server?
Explain what is the difference between a local and a global temporary table?
Explain features and concepts of analysis services?
Explain syntax for dropping triggers?
How to convert character strings into numeric values?
what is the difference between a primary key and a unique key? : Sql server database administration
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?
Explain powershell included in sql server 2008?
How can you append an identity column to a temporary table?
Explain unique key in sql server?
role of sql sever 2005 in database rather than any other database
How do I change my passwords (database, LDAP, and so on) without causing an outage?
can any body tell me how to know the password of current user in sql server
