What is the difference between DELETE TABLE and TRUNCATE TABLE commands?

Following are differences between delete & truncate commands:-

1)The DELETE TABLE syntax logs the deletes thus make the delete operation slow. The TRUNCATE table does not log any information but it logs information about deallocation of the data page of the table so TRUNCATE table is faster while the delete table is not fast.

2) The DELETE table can have criteria while TRUNCATE cannot.

3) The TRUNCATE table cannot trigger.

Posted Date: 9/24/2012 4:25:56 AM | Location : United States

Ask an Expert

Related Discussions:- Difference between delete table and truncate table commands, Assignment Help, Ask Question on Difference between delete table and truncate table commands, Get Answer, Expert's Help, Difference between delete table and truncate table commands Discussions

Write discussion on Difference between delete table and truncate table commands
Your posts are moderated

Write your message here..

Related Questions

Explain what user controls and server controls, Briefly explain what user c... Briefly explain what user controls are and what server controls are and the differences among the two.   An ASP.NET control (sometimes known as a server control) is a server-si

Looking for a solution to import the excel data, Project Description: I ... Project Description: I am having a table available in excel format and features the subsequent: - It has about 170000 rows - Some text is longer than 255 in length. - S

I need of an e-commerce website, I am concerned to doing like this project,... I am concerned to doing like this project, i have 5 years of experience in .net skill in engineering and computer related positions with devotement section, I am now a Senior Softw

Precautions for sqlserver mode, What are the precautions by which SQLSERVER... What are the precautions by which SQLSERVER Mode work properly Following are the things to keep in mind so that the SQLSERVER Mode works properly:- A) In the SQLSERVER mode,

Unicode, What is Unicode? In order to understand the concept of Unicode... What is Unicode? In order to understand the concept of Unicode we require  to move a little back and understand the ANSI code. The ASCII (ask key) stands for American Standard

Why is it preferred to not use finalize for clean up, The Problem with fina... The Problem with finalize is that the garbage collection has to make 2  rounds in order to remove the  objects which have finalize methods. The figure below will make things cle

Web service, What is a Web Service? The Web Services are the business l... What is a Web Service? The Web Services are the business logic components which provide the functionality via the Internet using standard protocols like HTTP. The Web Servic

Full time contractual programming position, Project Description: This is... Project Description: This is a full time contractual role seeking for a sports advisory service. We are data insights consultancy specializing in sports. We consult to a number

Xslt processor, What is XSLT? The XSLT is a rule based language used to... What is XSLT? The XSLT is a rule based language used to transform XML documents into other file formats. The XSLT are nothing but generic transformation rules which can be appl

What is reflection, What is Reflection?  It extends the advantages of m... What is Reflection?  It extends the advantages of metadata by allowing developers to inspect and use it at runtime. For example, dynamically determine all the classes contained