Call for Papers:Vol.5 Issue.4

Submission
Last date		 30-Aug-2019
Acceptance Status In One Day
Paper Publish In Two Days
Submit ManuScript

News & Updates

Submit Article

Dear Authors, Article publish in our journal for Volume-5,Issue-4. For article submission on below link: Submit Manuscript


Join As Board

Dear Reviewer, You can join our Reviewer team without given any charges in our journal. Submit Details on below link: Join As Board


Paper Publication Charges

IJARIIE APP
Download Android App

For Authors

Archives

IJARIIE Board

Downloads

Android App

Download IJARIIE APP

Authors

Title: :  A DIFFERENCE BETWEEN DELETE AND TRUNCATE IN SQL
PaperId: :  9261
Published in:   International Journal Of Advance Research And Innovative Ideas In Education
Publisher:   IJARIIE
e-ISSN:   2395-4396
Volume/Issue:    Volume 4 Issue 6 2018
DUI:    16.0415/IJARIIE-9261
Licence: :   IJARIIE is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.

Auther NameAuther Institute
Brijesh PatelS.B. Polytechnic
Jigisha TrivediS.B.POLYTECHNIC

Abstract

Computer Engineering
DDL, DML, DQL, DCL, TCL
While working with the database we often need to delete data, sometimes to create more space, sometimes just remove all data to make table ready for next day's transaction or sometimes just selectively remove stale data. SQL provides a couple of handy commands to remove data e.g. truncate, delete and drop. The last one is bit different because instead of removing data it just deletes table. What is the difference between truncate and delete command in SQL or when to use truncate vs delete is one of the most frequently asked SQL interview question? Knowledge of this critical command is not only useful for interviews, but also while working with a big database with a large number of records, especially while writing SQL scripts for purging transaction databases. An Incorrect choice of SQL command can result is either very slow processor can even blow up the log segment; if too much data needs to be removed and log segment is not enough. That's why it's critical to know when to use truncate and delete command in SQL. In this paper, we will first see few differences between them, and based upon them, you should be able to find out when DELETE is a better option for removing data or TRUNCATE should be used to purge tables.

Citations

Copy and paste a formatted citation or use one of the links to import into a bibliography manager and reference.

IJARIIE Brijesh Patel, and Jigisha Trivedi. "A DIFFERENCE BETWEEN DELETE AND TRUNCATE IN SQL" International Journal Of Advance Research And Innovative Ideas In Education Volume 4 Issue 6 2018 Page 37-43
MLA Brijesh Patel, and Jigisha Trivedi. "A DIFFERENCE BETWEEN DELETE AND TRUNCATE IN SQL." International Journal Of Advance Research And Innovative Ideas In Education 4.6(2018) : 37-43.
APA Brijesh Patel, & Jigisha Trivedi. (2018). A DIFFERENCE BETWEEN DELETE AND TRUNCATE IN SQL. International Journal Of Advance Research And Innovative Ideas In Education, 4(6), 37-43.
Chicago Brijesh Patel, and Jigisha Trivedi. "A DIFFERENCE BETWEEN DELETE AND TRUNCATE IN SQL." International Journal Of Advance Research And Innovative Ideas In Education 4, no. 6 (2018) : 37-43.
Oxford Brijesh Patel, and Jigisha Trivedi. 'A DIFFERENCE BETWEEN DELETE AND TRUNCATE IN SQL', International Journal Of Advance Research And Innovative Ideas In Education, vol. 4, no. 6, 2018, p. 37-43. Available from IJARIIE, http://ijariie.com/AdminUploadPdf/A_DIFFERENCE_BETWEEN_DELETE_AND_TRUNCATE_IN_SQL_ijariie9261.pdf (Accessed : 05 December 2018).
Harvard Brijesh Patel, and Jigisha Trivedi. (2018) 'A DIFFERENCE BETWEEN DELETE AND TRUNCATE IN SQL', International Journal Of Advance Research And Innovative Ideas In Education, 4(6), pp. 37-43IJARIIE [Online]. Available at: http://ijariie.com/AdminUploadPdf/A_DIFFERENCE_BETWEEN_DELETE_AND_TRUNCATE_IN_SQL_ijariie9261.pdf (Accessed : 05 December 2018)
IEEE Brijesh Patel, and Jigisha Trivedi, "A DIFFERENCE BETWEEN DELETE AND TRUNCATE IN SQL," International Journal Of Advance Research And Innovative Ideas In Education, vol. 4, no. 6, pp. 37-43, Nov-Dec 2018. [Online]. Available: http://ijariie.com/AdminUploadPdf/A_DIFFERENCE_BETWEEN_DELETE_AND_TRUNCATE_IN_SQL_ijariie9261.pdf [Accessed : 05 December 2018].
Turabian Brijesh Patel, and Jigisha Trivedi. "A DIFFERENCE BETWEEN DELETE AND TRUNCATE IN SQL." International Journal Of Advance Research And Innovative Ideas In Education [Online]. volume 4 number 6 (05 December 2018).
Vancouver Brijesh Patel, and Jigisha Trivedi. A DIFFERENCE BETWEEN DELETE AND TRUNCATE IN SQL. International Journal Of Advance Research And Innovative Ideas In Education [Internet]. 2018 [Cited : 05 December 2018]; 4(6) : 37-43. Available from: http://ijariie.com/AdminUploadPdf/A_DIFFERENCE_BETWEEN_DELETE_AND_TRUNCATE_IN_SQL_ijariie9261.pdf
BibTex EndNote RefMan RefWorks

Number Of Downloads


Last download on 12/5/2018 3:42:39 AM

Save in Google Drive

Similar-Paper

TitleArea of ResearchAuther NameAction
Decision Support System for Cosmetics Product using Sequential Pattern Mining based FP-Growth AlgorithmComputer EngineeringSoe Moe Myint Download
A Secure and Authorized Data De-duplication and Continuous Data AuditingComputer ScienceTrupti Deore Download
A Study Survey on the Deep Cryptographic data and its Algorithms ApplicationComputer Science and EngineeringKamali C Download
Using Deep Ensemble Learning & Deep CNN For Cancer PredictionArtificial Intelligence & Deep LearningShreyas Kulkarni Download
A COMPARITIVE STUDY OF ASYMMETRIC KEY CRYPTOGRAPHYComputer ScienceDr. Prashant P. Pittalia Download
COLLISION OF COMPACTNESS REPLICA AND ROUTINE ASSESSMENT OF AUTHORITY COMPETENT ETIQUETTE IN MOBILE ADHOC NETWORKComputer Engineering A.Nithya Download
DATA MANAGEMENT AND TRANSFER IN DISTRIBUTED E-COMMERCE SYSTEMComputer EngineeringSoe Moe Myint Download
Image Search Using Features and Social RankingComputer DepartmentNayan Nathu Sawant Download
A Review on Evaluative Measures in Image SegmentationComputer Science and EngineeringS. Bharathi Download
CRYPTOGRAPHY TO SECURE THE COMPUTER NETWORKComputer ScienceDr. Prashant P. Pittalia Download
Review of Evaluation of software understandability using software matricesComputer science & EngineeringApeksha Nayak Download
Evaluation of Software Understandability using Software MatricesComputer science & EngineeringApeksha Nayak Download
USING RASPBERRY PI HUMAN MACHINE INTERFACE TECHNOLOGY FOR VIRTUAL TALKING SYSTEM WITHOUT SENSOR AND VIRTUAL DISPLAY SYSTEM FROM VOICE COMMAND IMPLEMENTATIONComputer EngineeringRajashekar H V Download
Comparative Analysis of PyTorch and Caffe Frameworks.Computer Science EngineeringN Kanakapriya Download
Comparative analysis of Virtual Personal Assistant(s)Computer EngineeringDr. Sachin Upadhye Download
12