Submit a question
Home
Sql
What is difference between TRUNCATE & DELETE ?
Home
SQL Tuning
Ajax
ASP.Net
Bluetooth
CSS
C
C#
C++
Cobol
Computer Architecture
Data Structure
Data WareHousing
Database
Ejb
HR
Html
J2ee
J2ME
Java
JavaScript
JMS
JSP
Linux
Networking
Object Oriented(OOPS)
Operating System
PeopleSoft
PERL
Pl/Sql
Python
PHP
Puzzles
SAP-ABAP
Sql
Siebel
Struts
VB.NET
VB
UNIX
Xml
Submit a question
Link
Privacy - policy
Java Download
Login Form
Username
Password
Remember Me
Forgot your password?
Forgot your username?
Create an account
What is difference between TRUNCATE & DELETE ?
User Rating:
/ 0
Poor
Best
TRUNCATE commits after deleting entire table i.e., cannot be rolled back. Database triggers do not fire on TRUNCATE DELETE allows the filtered deletion. Deleted records can be rolled back or committed. Database triggers fire on DELETE.
Comments
Search
Only registered users can write comments!
Powered by
!JoomlaComment 3.26
3.26 Copyright (C) 2008 Compojoom.com / Copyright (C) 2007 Alain Georgette / Copyright (C) 2006 Frantisek Hliva. All rights reserved."
< Prev
Next >
Related links
Related Links:
Related Images
Related Links:
