Call for Papers:Vol.11 Issue.4

Submission
Last date		 28-Aug-2025
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-11,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.

Author NameAuthor 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 : 06 October 2023).
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 : 06 October 2023)
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 : 06 October 2023].
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 (06 October 2023).
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 : 06 October 2023]; 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 10/6/2023 9:02:53 AM

Save in Google Drive

Similar-Paper

TitleArea of ResearchAuther NameAction
Real-Time Hand Gesture Recognition with Finger Counting (Using OpenCV and Mediapipe)Computer scienceBhumika Sahu Download
Diffie Hellman Key Exchange Algorithm with Man in the middle attack (MITM)Computer Science EngineeringMahesh Purushottam Gajbhiye Download
AN IMPROVED ATTRIBUTE BASED ACCESS CONTROL IN PERSONAL HEALTH RECORDS USING CLOUD WITH CONSTANT CIPHERTEXT LENGTHScience and TechBitrus Isahaka Dzarma Download
Driver Drowsiness Detection System By Measuring EAR and MARComputer Engineering Zoya Fatema Khan Download
Cloud-Based File Storage and Sharing Web ApplicationComputer Science & EngineeringMohammed Aadil Download
STUDYNEST: ONLINE LEARNING PLATFORM WITH AI RECOMMENDATION SYSTEMComputer Science and Engineering Urvashi Suresh Waghmare Download
Leveraging AWS for Developing and Hosting a Dynamic Food Ordering Web ApplicationComputer EngineeringAfshin Khanam Download
Edge-to-Cloud Synergy: An Autoencoder-GAN Framework for Anomaly Detection in Healthcare Records, Financial Statements, and Secure Cloud StorageInformation TechnologyKarthik Kushala Download
E-Commerce Fraud Detection Based on Machine Learning TechniquesComputer Science EngneeringVikram Ankush Ade Download
Detection of Phishing Website Using Gradient Boosting AlgorithmComputer Science and EngineeringYAWALKAR PRASAD PRAMOD Download
Property Dealing WebComputer Science EngineeringYash Chaudhari Download
Reinforcement Learning for the Evolution of Antimicrobial Nano formulationsmachine learningMadhusudan Download
SecuraVault: A secured blockchain based cloud storage systemComputer Engineering Anshika Jaiswal Download
Autoimmune Disease Detection in women Using Machine Learning Approachcomputer science EngineeringJ. L. V. S. Download
Medicine Overdose Detection System Using Machine LearningComputer Science EngineeringDr.Somashekhar B M Download
12