Difference between delete table and truncate table commands, DOT NET Programming

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







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
Related Questions
Find out the Factorial - C# Program I've been trying so many codes for this but those codes didn't work well. Please write the code for find out the factorial of an integer nu

What is a static constructor? Static constructors are introduced with C# to initialize the static data of a class. CLR calls the static constructor before the initial instance

ASP.NET/MSSQL/ MVC completing backend solution + integrating with frontend. Project Description: System is used for tracking company's activities through several projects by

Web-App Developer for Startup Project Description: I am seeking someone who is good at building dynamic sites that will run on both desktops and tablets. The core of the w

how can i construct er diagram for payroll managment

What is Common Type System (CTS)? CTS is the component of CLR by which .NET Framework provides support for multiple languages because it have a type system that is common acros

mailer - mail sender Project Description: I want a mailer: -run on Windows Server 2008 -use how many theard i need -more details speak on private Skills required

Work on different coding using visual studio 2012/2013 writing Java script as well as C# codes. Project Description: I want to shift to new Programming Env. and I would like

Duplicate a Website I need a customer management site Please help me out and what I need to get. I need all charteristics of above mentioned site a) Effects b) Mobil

What is ACID fundamental? What are transactions in SQL SERVER? The transaction is a sequence of operations performed as a single logical unit of work..The logical unit of work