Home Tutorialhelp Comment difference between TRUNCATE and DELETE

 
 

Comment

kipy
difference between TRUNCATE and DELETE ,
April 5, 2010 at 10:15 AM

15. What is the difference between TRUNCATE and DELETE commands?

TRUNCATE: ONLY A SMALL PART OF THE TABLE OR DATABASE IS TRUNCATED (DELETED)

DELETE: WHOLE CONTAINS OF THE TABLE OR DATABASE IS DELETED.


View All Comments
Advertisement
Related Tutorial and Articles
SQL Question

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 

Programming Tutorials

Deadlock
_CONSTRAINTS. 15. What is the difference between TRUNCATE and DELETE commands... is used to find the difference between two dates? MONTHS_BETWEEN. 27... the condition will be copied to the new table. 35. TRUNCATE TABLE EMP; DELETE FROM 

SQL Question

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 

SQL Question

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 

SQL Question

difference
difference  what's the difference between mysql and sql 

SQL Question

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, Both HAVING and WHERE clause used for specifying the search condition in SQL 

SQL Question

What is the Delete Statements in SQL?
What is the Delete Statements in SQL?  What is the Delete Statements in SQL?   Hi, Here is the answer, Delete statement in SQL is used... of partial delete depending upon our criterias otherwise use TRUNCATE to delete whole 

SQL Question

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 

PHP Questions

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

SQL Question

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... be hard-coded into the application.Static SQL is usually targeted at a specific 

SQL Question

sql
difference between sql and oracle  what is the difference between sql and oracle 

SQL Question

Deadlock
Deadlock  hii, What is deadlock?   hello, Deadlock is a situation when two or more processes prevent each other from running 

SQL Question

Calculate Month Difference in mysql - SQL
Calculate Month Difference in mysql  hi , i am rahul.Can anybody plz help me.i am calculating month difference in mysql5.0 procedure . i have done coding for it. it's counting difference between months. but what i want 

JDBC Questions

difference between statement and a prepared statement - JDBC
difference between statement and a prepared statement  What is the difference between statement and a prepared statement?  A Statement.... Most relational databases handles a JDBC / SQL query in four steps 

JDBC Questions

difference
difference  difference between hashtable and hashtree 

Java Beginners

Difference
Difference  What Is the difference between JDK & SDK 

Java Interview Questions

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

Java Server Faces Questions

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

Struts Questions

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

JavaScript Questions

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

Struts Questions

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

SQL Question

Difference between Normal Insert and BLOB insert
Difference between Normal Insert and BLOB insert  I have sql database with table Images, in that table there are 2 Columns ID (identity.... So what is the difference?? and what changes i have to make in order to runn 

JDBC Questions

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 

Java Beginners

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 

Java Beginners

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 

Java Beginners

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 

Mobile Applications Questions

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

SQL Question

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

SQL Question

SQL
SQL  1)What is ref cursor? Where u can use this ref cursor? 2)What is difference between procedure and function? 3)What is trigger? How many types of triggers are there? 4)What is cursor? Explain different types of Cursors 

Java Interview Questions

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 

Java Beginners

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 

JSP Interview Questions

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 

Java Beginners

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 

JSP Interview Questions

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 

SQL Question

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 

Servlet Interview Questions

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 

JSP Interview Questions

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 

JSP Interview Questions

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 

Java Interview Questions

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

Java Beginners

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

Swing AWT

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 

Java Beginners

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 

Java Magazine Questions

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 

PHP Questions

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 

Framework Questions

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 

SQL Question

sql - SQL
HAVING n>1; Difference between SQL and PL/SQL: SQL is a structured query... want query? 4.what is the diffrence between sql and plsql?  Hi Friend...(select,insert,update etc.), manipulate objects(DDL) and data(DML). PL/SQL 

Hibernate Questions

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 

Java Interview Questions

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

Java Beginners

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

Java Interview Questions

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

PHP Questions

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

JSP Interview Questions

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

XML Questions

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

SQL Question

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

PHP Questions

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

Java Beginners

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 

Java Beginners

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 

SQL Question

SQL help - SQL
SQL help  Hi Deepak, Can u pls tell me what is the difference between PL/SQL and MYSQL? Is there any difference in generating the code 

Java Interview Questions

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 

JavaScript Questions

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 

Java Beginners

difference between prepared statement and statement
difference between prepared statement and statement  i mean in prepared statement we write insert command as INSERT INTO tablename VALUES...(),jtextfield2.getText()); whats the difference between these two and which is more 

Hibernate Questions

Difference between and merge and update in hibernate
Difference between and merge and update in hibernate  What is difference between and merge and update in hibernate?   Use update() if you are sure that the session does not contain an already persistent instance 

Struts Questions

Difference between MVC1 And MVC2 - Struts
Difference between MVC1 And MVC2  HI Friends,Can u Give me difference between mvc1 and mvc2. Thanks Prakash  Hi Friend, Please visit the following link: http://www.roseindia.net/struts/mvc-architecture.shtml 

SQL Question

mysql difference between two numbers
mysql difference between two numbers  How to get total bate difference between two dates for example 1/01/2012 and 1/02/2012 in MYSQL?   ..., '01/02/2012', 103))   DATEDIFF() in MYSQL always returns the difference 

Java Interview Questions

Java deadlock
Java deadlock  What is deadlock 

Database-Tutorials

What is the difference between MongoDB and MySql?
The difference between MongoDB and MySql is that the in former one whole document is read while in latter rows and columns are read. Embedded documents... language on the other hand MySql Dynamic query method uses SQL (Structured Query 

JSP Servlet Questions

Sql delete operation
Sql delete operation  Hi, I am tried to several times but i am... yyyy 95643663 update delete 2 aaaa bbbb 64645666 update delete update and delete are enclosed with html anchor element. if i 

Java-Tutorials

Deadlock
Deadlock      ..., this situation is known as Deadlock. Lets see a situation in the diagram shown below where the deadlock condition is occurred 

Java Beginners

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 

Java Beginners

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 

Java Beginners

difference between enum and final class?
difference between enum and final class?  what is the difference between enum and final class in java?   The java.lang.Enum is an abstract class, it is the common base class of all Java language enumeration types 

Java Beginners

difference between wite and writeto in java
difference between wite and writeto in java  I am using the stream to write content to the file.I am using write() method but my friend suggest the writeTo() method. I want to know difference between the write() and writeTo 

Servlet Interview Questions

difference between servletconfig and servletcontext in java
difference between servletconfig and servletcontext in java  difference between servletconfig and servletcontext in java   ServletContext ServletContext is implemented by the servlet container for all servlet 

Flex Questions

Difference between httpService and Data Service
Difference between httpService and Data Service  Hi.. Please tell me What is the difference between httpService and Data Service? Thanks  Solution: When we use flex Data Services we have to need 

SQL Question

oracle - SQL
oracle  what is the difference between sql *plus and isql *plus 

SQL Tutorial

SQL Introduction
SQL Introduction       Quick Introduction to SQL: SQL is Structure Query Language. This Query... Standards institute). The SQL have own statement, which helps you to perform various 

Hibernate-Tutorials

Difference Between cascade and inverse Keyword
Difference Between cascade and inverse Keyword In this tutorial we are going to differentiate between the cascade option and inverse keyword. Cascade... in the relationship between the associated objects. It is an optional attribute that may be used 

Hibernate Questions

Difference between getCurrentSession() and openSession() in Hibernate ?
Difference between getCurrentSession() and openSession() in Hibernate ?  What is difference between getCurrentSession() and openSession() in Hibernate ?   getCurrentSession() : The "current session" refers 

Java Beginners

difference between the obj and reference - Java Beginners
difference between the obj and reference  what is the difference between object and reference ? is there any difference 

Java Interview Questions

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 

Java Interview Questions

difference between servletconfig and servletcontext in java
difference between servletconfig and servletcontext in java  ServletConfig is implemented by the servlet container to initialize a single servlet using init(). ServletContext is implemented by the servlet container for all 

JDBC

Difference between JDBC 3.0 & JDBC 4.0
Difference between JDBC 3.0 & JDBC 4.0   ... point for inserts int rowcount=st.executeUpdate("delete from employee"); connection.rollback(sv); //discard the delete statement but keeps 

Java Beginners

Difference between documentation comment and multiline comment in java?
Difference between documentation comment and multiline comment in java?  Difference between documentation comment and multiline comment in java 

Java Beginners

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 

Java Beginners

Difference between declaring variables before or in loop?
Difference between declaring variables before or in loop?  Difference between declaring variables before or in loop 

Spring Framework Questions

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 

Hibernate Questions

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 

Java Beginners

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 

Java Interview Questions

DIFFERENCE BETWEEN APPLICATION SERVER AND WEB SERVER
DIFFERENCE BETWEEN APPLICATION SERVER AND WEB SERVER  What is the difference between application server and web server 

JSP Servlet Questions

calculate difference between two time in jsp
calculate difference between two time in jsp  How to calculate difference between two dates 

PHP Questions

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

PHP Questions

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 

Java Beginners

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

PHP Questions

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 

PHP Questions

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 

Java Beginners

Difference between object and instance? - Java Beginners
Difference between object and instance?  What is the difference between object and instance in java 

Servlets-Tutorials

Difference Between Servlet and JSP
Difference Between Servlet and JSP In this section we will describe the Servlet and JSP. We will compare the both technologies. We will discuss the differences between Servlet and JSP. Servlet Servlet is a Java class that is usually 

Spring Framework Questions

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 

Java Beginners

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 

Java Interview Questions

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 

Advertisements Advertisements
 

 

 

DMCA.com