What is difference between TRUNCATE & DELETE

What is difference between TRUNCATE & DELETE

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,









Related Tutorials/Questions & Answers:
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,ADS_TO_REPLACE_1 TRUNCATE is a DDL command whereas DELETE is a DML command. TRUNCATE is much
Advertisements
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 extends and implements
what is the difference between extends and implements  difference between extends and implements
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 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 pop and oop
what is the difference between pop and oop  what is the difference between pop and oop
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 HereADS_TO_REPLACE_1 Thanks
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
What is the difference between JPA and Hibernate?
What is the difference between JPA and Hibernate?  Hi, I have seen... it for enterprise applications and there is good demand in market. What is the difference between JPA and Hibernate? What a beginner should learn? Thanks   Hi
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:ADS_TO_REPLACE_1 1) Java is a Object Oriented programming language developed
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 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 difference between singleton and prototype bean?
What is difference between singleton and prototype bean?  Hi, What is difference between singleton and prototype bean? Thanks
What is the difference between JSF, Servlet and JSP?
What is the difference between JSF, Servlet and JSP?  What is the difference between JSF, Servlet and JSP
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
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... criteria in SELECT, DELETE, UPDATE statements. Thanks,ADS_TO_REPLACE_2
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
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
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
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 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
What is difference between UNIX Hosting and Window Hosting?
What is difference between UNIX Hosting and Window Hosting?  Which... to learn about these technologies. What is difference between UNIX Hosting... the tutorial What is difference between UNIX Hosting and Window Hosting . Thanks
What is the difference between a data analyst and a data scientist?
What is the difference between a data analyst and a data scientist?  ... for the tutorials to learn: What is the difference between a data analyst... can learn the topic "What is the difference between a data analyst
What is difference between data analyst and data scientist?
What is difference between data analyst and data scientist?  Hi, I... for the tutorials to learn: What is difference between data analyst and data scientist... the topic "What is difference between data analyst and data scientist?"
what is the difference between frontcontroller and actionservlet? - Struts
what is the difference between frontcontroller and actionservlet?   Hi Roseindia, sub: what is the difference between frontcontroller and actionservlet? Thank you. RamehReddy T.  frontcontroller
What is the difference between an if statement and a switch statement?
What is the difference between an if statement and a switch statement?   Hi, What is the difference between an if statement and a switch statement? Thanks,   Hi, The if statement gives options to select one option
What is the difference between Big Data and Hadoop?
What is the difference between Big Data and Hadoop?  Hi, People... from these technologies. What is the difference between Big Data and Hadoop? Please provide me detailed difference in Big Data and Hadoop. Thanks  
What is the difference between Big Data and Hadoop?
What is the difference between Big Data and Hadoop?  Hi, People... from these technologies. What is the difference between Big Data and Hadoop? Please provide me detailed difference in Big Data and Hadoop. Thanks  
What is the difference between static and dynamic SQL?
What is the difference between static and dynamic SQL?  What is the difference between static and dynamic SQL?   Hi, Static SQL is SQL statements in an application that do not change at runtime and, therefore, can
What is the difference between a break statement and a continue statement?
What is the difference between a break statement and a continue statement?   Hi, What is the difference between a break statement and a continue statement? Thanks,   Hello, In Java programming language supports 3
What is the difference between EJB 3.0 and JPA - Framework
What is the difference between EJB 3.0 and JPA   What is the difference between EJB 3.0 and JPA. How can they work together. Does EJB 3.0 need... which can be used for creating a mapping between plain java bean objects (POJO
What is difference between Core Java and Advanced Java?
What is difference between Core Java and Advanced Java?  Hi, I want to know about Core Java and Advanced Java. How should I learn these technologies? What is difference between Core Java and Advanced Java? Thanks   
What is difference between JDK,JRE and JVM?
What is difference between JDK,JRE and JVM?  Hi, As a beginner I want to know the beginning information for learning Java. I am new to Java... beginner material. What is difference between JDK,JRE and JVM? Explain me
What is difference between Core Java and Advanced Java?
What is difference between Core Java and Advanced Java?  Hi, I want to know about Core Java and Advanced Java. How should I learn these technologies? What is difference between Core Java and Advanced Java? Thanks   
What is the difference between mysql_fetch_object and mysql_fetch_array?
What is the difference between mysql_fetch_object and mysql_fetch_array?  What is the difference between mysqlfetchobject and mysqlfetcharray
what is the difference between jdk 1.4 and 1.5 and 1.6
what is the difference between jdk 1.4 and 1.5 and 1.6  what is the difference between jdk 1.4 and 1.5 and 1.6   Java 1.4 Features...: automatic conversions between primitive types (such as int) and primitive wrapper

Ads