Difference between TRUNCATE and DELETE commands

Home Answers Viewqa SQL Difference between TRUNCATE and DELETE commands

QuestionAsk Questions?

samar

Difference between TRUNCATE and DELETE commands
2 Answer(s) 2 years and 7 months ago
Posted in : SQL

hii,

What is the difference between TRUNCATE and DELETE commands?

View Answers

October 28, 2010 at 4:08 PM

hello,

TRUNCATE is a DDL command whereas DELETE is a DML command.
TRUNCATE is much faster than DELETE.

October 21, 2011 at 8:29 AM

truncate and delete both are used to delete data from SQL but the way they work is entirely different and quite important to understand to avoid crashing your database especially if you are working with a large data with huge data. when you delete data using delete command in SQL every row operation is logged and if you going to delete too much data your log segment may blew up, while with truncate its not the case. See here for more differences

Difference between TRUNCATE and DELETE commands
Difference between TRUNCATE and DELETE commands hii, What is the difference between TRUNCATE and DELETE commands? hello, TRUNCATE is a DDL command whereas DELETE is a DML command. TRUNCATE is much faster than

What is difference between TRUNCATE & DELETE
What is difference between TRUNCATE & DELETE What is difference between TRUNCATE & DELETE? Hi, The DELETE command is used... a DELETE operation you need to COMMIT or ROLLBACK the transaction to make the change

DROP a table and TRUNCATE
DROP a table and TRUNCATE What are the differences between DROP a table and TRUNCATE a table

What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE? What is the difference between a HAVING CLAUSE and a WHERE CLAUSE? Hi..., DELETE, UPDATE statements. Thanks

Some Common Types of FTP Commands
it is important to know some common types of FTP commands. Though, many FTP commands are different in different commands but some of the commands are same regardless of the computer or operating system. Some commands are executed without any

difference
difference difference between hashtable and hashtree

difference
difference what's the difference between mysql and sql

Difference between API and Assembly - Java Beginners
Difference between API and Assembly Can anybody tell me what is the diffrenece between API's and assemblies? Hi friend, Points...." *) It is a set of commands, functions, and protocols. *) It build software

Difference
Difference What Is the difference between JDK & SDK

Difference between DispatchAction and LookupDispatchAction
Difference between DispatchAction and LookupDispatchAction What is the Difference between DispatchAction and LookupDispatchAction

difference between SessionState and ViewState
difference between SessionState and ViewState What is the difference between SessionState and ViewState

difference between ForwardAction and IncludeAction
difference between ForwardAction and IncludeAction What is the difference between ForwardAction and IncludeAction

Difference between struts and JSF
Difference between struts and JSF What is the difference between struts and JSF

difference between == and === operators?
difference between == and === operators? Is (====) operator available in java or not? difference between

difference
difference what is the difference between the JDBC-ODBC bridge, the Native-API-Partly-Java driver, and the JDBC-Net-All-Java Driver is the placement of the database access libraries Please visit the following link

difference
difference difference between thread and process in java Difference between Process and Thread: 1)Process is a program under execution whereas Thread is a part of program. 2)Process are heavy weight programs which

difference
difference difference between Method Overloading and method Overriding Difference between Method Overloading and Method Overriding: Overriding is the concept of having functions of same name and signature

Difference between 3d and 4d
Difference between 3d and 4d what is the difference between 3d and 4d

What is the difference between the >> and >>> operators?
What is the difference between the >> and >>> operators? hi, What is the difference between the >> and >>> operators? Thanks

difference between varchar & varchar2?
difference between varchar & varchar2? What is the difference between varchar & varchar2

Difference between Mysql and SQL
Difference between Mysql and SQL hello, What is the difference between Mysql and SQL?? hii, SQL is structural quary language but mysql is database package

Difference between Timer and Thread?
Difference between Timer and Thread? Can anyone tell me about the difference between Timer and Thread, Why we need to have Timer in case we have Thread implimentation startegy in Java

Difference between JSP and Servlets
Difference between JSP and Servlets What is the difference between JSP and Servlets ? JSP is used mainly for presentation only. A JSP can only be HttpServlet that means the only supported protocol in JSP is HTTP

difference between lock and synchronization
difference between lock and synchronization Hi, I am new in java please anyone tell me difference between lock and synchronization in java. its urgent. Thank in advance Please visit the following link: Lock

Difference between SCJP Exams
Difference between SCJP Exams What is the differences between SCJP 5 (310 - 055) exam and SCJP 6 (310 - 065) exam??? Thank You In Adv

Difference between request.getRequestDispatcher() and context.getRequestDispatcher()
Difference between request.getRequestDispatcher() and context.getRequestDispatcher() What is the difference in using request.getRequestDispatcher() and context.getRequestDispatcher()? request.getRequestDispatcher

Difference between translate and replace
Difference between translate and replace hiii, What is the difference between translate and replace? hello, Replace replace every instence of character with character sting by the given charator of string

Difference between forward and sendRedirect
Difference between forward and sendRedirect What's the difference between forward and sendRedirect? RequestDispatcher.forward() and HttpServletResponse.sendRedirect() are the two methods available for URL redirecting

Difference between ServletContext and ServletConfig
Difference between ServletContext and ServletConfig What is the difference between ServletContext and ServletConfig? ServletContext :Defines a set of methods that a servlet uses to communicate with its servlet

Difference between GET and POST
Difference between GET and POST Difference between GET and POST ? The difference between a GET and a POST is the way data is transferred to a servlet. With a GET, the URL will show each name/value pair on the query

what is the difference between extends and implements
what is the difference between extends and implements difference between extends and implements

difference between applet and swings
difference between applet and swings what are the major difference between swing and applets Hello Friend, Differences: 1) AWT stands... this feature is not supported by AWT. Thanks Hi Friend, Difference

Difference between http and https
Difference between http and https Difference b/w HTTP and HTTPS please provide answer in tabular form. Hi Friend, Differences: 1)HTTP is hyper text transfer protocol which is responsible for transmitting

Difference between error and exception ????????
Difference between error and exception ? Can we handle a error in java if yes than give an code of an example? Difference between error and exception handling....... Exceptions are things you can create/throw

Difference between Struts and Spring
Difference between Struts and Spring What are the difference between Struts and Spring? Hi Friend, Differences: 1)Struts is a web framework while Spring is not. 2)Spring is a Layered Architecture while Struts

difference between $message and $$message
difference between $message and $$message What is the difference between $message and $$message? Hi friends, $message is a simple variable whereas $$message is a reference variable. Example: $name = 'Bharat

What is the difference between PHP4 and PHP5?
What is the difference between PHP4 and PHP5? What is the difference between PHP4 and PHP5

Difference between XML and HTML - XML
Difference between XML and HTML What is the basic Difference between XML and HTML

difference between <%@ include ...> and <jsp:include>
difference between <%@ include ...> and What is the difference between <%@ include ...> (directive include) and <jsp:include>

What is the difference between $message and $$message?
What is the difference between $message and $$message? What is the difference between $message and $$message

what is the Difference between weblogic and jboss?
what is the Difference between weblogic and jboss? what is the Difference between weblogic and jboss

what is the difference between pop and oop
what is the difference between pop and oop what is the difference between pop and oop

difference between hashcode,reference in java
difference between hashcode,reference in java difference between hashcode,reference in java

What is the difference between hibernate and spring
What is the difference between hibernate and spring Hi, What is the difference between hibernate and spring. Thanks

What is difference between a PROCEDURE & FUNCTION ?
What is difference between a PROCEDURE & FUNCTION ? What is difference between a PROCEDURE & FUNCTION

What is the difference between a constructor and a method?
What is the difference between a constructor and a method? Hi, What is the difference between a constructor and a method? Hi, I have found a good link of Java program related to difference between constructor

Difference between jsonstring and json object
Difference between jsonstring and json object Is There any difference between JsonString and jsonobjectA? if there is any differece could any one explain with example. Thanks venkatesh

What is difference between the java and javascript?
What is difference between the java and javascript? What is the difference beteen the java and javascript? Hello Friend, Read Here Thanks

calculate difference between two dates
calculate difference between two dates hi, I was actually working on to calculate the number of days between two dates of dd/mm/yyyy format... the difference between the two dates

Ask Questions?

If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.

Ask your questions, our development team will try to give answers to your questions.

Tutorial Topics