What is difference between TRUNCATE & DELETE

Home Answers Viewqa SQL What is difference between TRUNCATE & DELETE

QuestionAsk Questions?

hemant kumar

What is difference between TRUNCATE & DELETE
1 Answer(s) 2 years and 6 months ago
Posted in : SQL

What is difference between TRUNCATE & DELETE?

View Answers

November 20, 2010 at 12:26 PM

Hi,

The DELETE command is used to remove rows from a table. A WHERE clause can be used to only remove some rows. If no WHERE condition is specified, all rows will be removed. After performing a DELETE operation you need to COMMIT or ROLLBACK the transaction to make the change permanent or to undo it.

TRUNCATE removes all rows from a table. The operation cannot be rolled back and no triggers will be fired. As such, TRUCATE is faster and doesn't use as much undo space as a DELETE.

Thanks,

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

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

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 the >> and >>> operators?
What is the difference between the >> and >>> operators? hi, What is the difference between the >> and >>> operators? Thanks

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

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

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

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 $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

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 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

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

difference
difference what's the difference between mysql and sql

What is the difference between a JDK and a JVM?
What is the difference between a JDK and a JVM? Hi, What is the difference between a JDK and a JVM? Thanks, Hi, JDK is stand... to compile your source files using a JVM. For more difference between JDK and JVM

What is difference between Path and Classpath?
What is difference between Path and Classpath? hi What is difference between Path and Classpath? thanks Hi, The Path & Classpath are used for operating system level environment variales. We mostly use Path

Difference
Difference What Is the difference between JDK & SDK

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, Difference: 1) Java is a Object Oriented programming language developed by Sun Microsystems

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

What are the difference between abstract class and interface?
What are the difference between abstract class and interface? What are the difference between abstract class and interface

What’s the difference between include and require?
What?s the difference between include and require? What?s the difference between include and require

what is the difference between distributed application and web application?
what is the difference between distributed application and web application? what is the difference between distributed application and web application

What’s the difference between load() and get()?
What?s the difference between load() and get()? Hi, What?s the difference between load() and get()? thanks

What is the difference between ereg_replace() and eregi_replace()?
What is the difference between ereg_replace() and eregi_replace()? What is the difference between eregreplace() and eregireplace

What is the difference between the functions unlink and unset?
What is the difference between the functions unlink and unset? What is the difference between the functions unlink and unset

What is difference between singleton and prototype bean?
What is difference between singleton and prototype bean? Hi, What is difference between singleton and prototype bean? Thanks

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 between varchar & varchar2?
difference between varchar & varchar2? What is the difference between varchar & varchar2

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

what is difference between objectan primitive? - Java Beginners
what is difference between objectan primitive? whatis difference between object and primitive

what is the difference between productList==null and productList.size()==0
what is the difference between productList==null and productList.size()==0 what is the difference between productList==null and productList.size()==0? here productList is of type LIST

What is the difference between the Boolean & operator and the && operator?
What is the difference between the Boolean & operator and the && operator? Hello, What is the difference between the Boolean & operator and the && operator? thanks

What are difference between Bean Factory and Application Context ?
What are difference between Bean Factory and Application Context ? Hi, What are difference between Bean Factory and Application Context

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

what is the difference between the eclipse and myeclipse - IDE Questions
what is the difference between the eclipse and myeclipse what is the difference between the eclipse and myeclipse Hi Friend, Difference: Eclipse is an IDE or platform for developing, whereas MyEclipse

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

What is the difference between component and tag in JSF?
What is the difference between component and tag in JSF? Please let me know,becaus i am new to jsf and am confusing

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 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

What is the difference between UNION and UNION ALL in SQL?
What is the difference between UNION and UNION ALL in SQL? What is the difference between UNION and UNION ALL in SQL? Hi, UNION is an SQL keyword used to merge the results of two or more tables using a Select

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 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

What is the difference between GET and POST method?
What is the difference between GET and POST method? In PHP, both GET... there is a lots of difference between the both. Can anyone please explain...;difference between get and post method in PHP POST method is more secure than GET

What is the difference between IN and BETWEEN, that are used inside a WHERE clause?
What is the difference between IN and BETWEEN, that are used inside a WHERE clause? What is the difference between IN and BETWEEN, that are used inside a WHERE clause? Hi, The BETWEEN clause is used to fetch a range

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