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

Web application and web service, Web Application and Web Service For t... Web Application and Web Service For this part of the assignment, you are to develop a web application and web service using technologies and techniques taught in this subject

What is the use of the commandbuilder class, What is the use of the Command... What is the use of the CommandBuilder class? The CommandBuilder class is used to automatically update a database according to the changes made in a DataSet. This class autom

Best practice while implement globalization & localization, What are the be... What are the best practices while implementing globalization and localization? The best methods while developing international language support software are shown below:- 1)

Django and python junior developer, Project Description: We require an e... Project Description: We require an expert developer to work on several projects for our company. You will be managed by our senior developer. Required - MUST be proficient in

Install modules to enhance site proformance, Install Modules to enhance Sit... Install Modules to enhance Site Proformance Project Description: As shown, I need the subsequent modules installed, to improve loading time for my graphics and images, improv

Develop outlook add-in for all versions, Develop Outlook Add-In for all ver... Develop Outlook Add-In for all versions I need simple code for Outlook(express,2003,2007,2010,2013) Add-In with functionality to repeatedly send CC to the specified email(s), th

Software testing, Project Description: i will testing some software whic... Project Description: i will testing some software which you need and i promise to do my job is the best way, and as fast as possible. Skills required: .NET, MySQL, C# P

Value types and reference types, What are Value types and Reference types ... What are Value types and Reference types The Value types directly contain their data which are either allocated on the stack or allocated in-  Line in a  structure. The Refe

Modification in .net website, Modification in .net website I need some m... Modification in .net website I need some modification in asp.net website. It's an e-commerce site. Skills required: .NET, HTML, eCommerce, Shopping Carts, Website Design

Difference between localization and globalization, What's the difference be... What's the difference between localization and globalization? Globalization: The Globalization is a process of developing a program core whose features and code design are no