What is difference between TRUNCATE & DELETE

Ads
 

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,

Ads









Related Tutorials/Questions & Answers:
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
Advertisements
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 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 $message and $$message?
What is the difference between $message and $$message?  What is the difference between $message and $$message
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 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 JSF, Servlet and JSP?
What is the difference between JSF, Servlet and JSP?  What is the difference between JSF, Servlet and JSP
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 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 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 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 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 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 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 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 access specifiers and access modifiers in java?
what is the difference between access specifiers and access modifiers in java?  what is the difference between access specifiers and access modifiers in java
What is the difference between a static and a non-static inner class?
What is the difference between a static and a non-static inner class?   Hi, What is the difference between a static and a non-static inner class? Thanks
In Java, what's the difference between public, default, protected, and private?
In Java, what's the difference between public, default, protected, and private?  In Java, what's the difference between public, default, protected, and private
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 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   

Ads