Call for Papers:Vol.12 Issue.1

Submission
Last date		 28-Feb-2026
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-12,Issue-1. 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, https://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: https://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: https://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: https://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
MULTIPLE DISEASE PREDICTION AND DRUG RECOMMENDATION SYSTEM USING MACHINE LEARNINGCOMPUTER ENGINEERING DR. J. AMUTHARAJ Download
SOLAR TRACKING SYSTEM WITH WEATHER FORECASTING AND AUTOMATED CLEANING SYSTEMArtificial Intelligence Electrical and Electronics EngineeringVanarasan S Download
ASD PredictionComputer scienceAbhilasha M Download
Music Recommendation based on Face Emotion Using Artificial Intelligence and Machine LearningInformation Science EngineeringDr. Sreenivasa Murthy V Download
SMART TRAFFIC AI MONITORING SYSTEM-AI/MLINFORMATION SCIENCE AND ENGINEERING PRIYANKA MT Download
SHADOW THE WEB BROWSERComputer Science and EngineeringLakshmi Narayan S Download
SECUHIRE – AI-POWERED INTERVIEW DETECTION SYSTEMComputer Engineering Tharun R Download
Early Detection Of Electrical Fault Line Using Artificial IntelligenceElectrical Engineering , Computer Science , Artificial IntelligenceRakshitha R Download
Real Time Object Detection Tracking using YOLO and Deep SORTInformation science and engineeringNandan M R Download
An AI-Integrated Intelligent Health Advisory System with Machine-Learning-Based Ayurvedic Formulation RecommendationInformation Science EngineeringSrinidhi G Download
Blockchain-Based Decentralized Medical Health Management System using Smart Contracts and IPFS Information Science and EngineeringVarun V Download
Precision Agriculture Using Machine Learning and IOTComputer Science and EngineeringRamesh B E Download
A Secure Blockchain Based Voting SystemComputer Science and EngineeringSagar K R Download
Chatbot based helpdesk for Government employee and departmentsComputer science & Engineering(Cyber Security Engineerting)Dr. Shanthi S Download
Zero Trust ArchitectureComputer EngineeringAditya Yanna Download
12