Call for Papers:Vol.9 Issue.1

Submission
Last date		 26-Feb-2023
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-9,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, http://ijariie.com/AdminUploadPdf/A_DIFFERENCE_BETWEEN_DELETE_AND_TRUNCATE_IN_SQL_ijariie9261.pdf (Accessed : 15 January 2020).
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 : 15 January 2020)
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 : 15 January 2020].
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 (15 January 2020).
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 : 15 January 2020]; 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 1/15/2020 9:26:39 PM

Save in Google Drive

Similar-Paper

TitleArea of ResearchAuther NameAction
An Overview of Data Visualization techniques, features and their critical analysisComputer EngineeringV Maddileti Reddy Download
METRO CITY SCRAP MANAGEMENT SYSTEMComputer EngineeringChaitnya Shelke Download
Personal Security SystemComputer Science and EngineeringShaikh Mohd Abdul Hannan Download
DEVELOPMENT OF BIOMETRIC FACE RECOGNITION SYSTEMComputer Sciene Dr. Rupali Telgad Download
AI Suspicious Activity Detection using Human Pose EstimationComputer Engineering YATHESHVAMSI NAIDU K Download
Air Pollution Classification using ML and IoTComputer EngineeringMALAVIKA K S Download
Automated Time Table Generator SystemComputer EngineeringKishori Ghule Download
Krushi sarthi android applicationcomputer engineeringShaikh wajit rustum Download
Brain tumor Detection by Using segmentationComputer Sciene Dr. Rupali Telgad Download
CONTEXTUAL AI ASSISTANT USING TRANSFORMERS AND NLPComputer Science and TechnologyAnant Kumar Gupta Download
Image Steganography- A Research PaperComputer Science and EngineeringVaibhavi Sushil Download
Text Translation and Audio StreamingComputer Science and EngineeringDona Davis Download
Natural Language Processing Role in Medical ChatbotComputer Science and EnginerringMr. Devaraj F V Download
Literature Survey of Veterinary WebsiteComputer EngineeringSandeep A S Download
Crime Pattern Detection Using Historical DataComputer Science EngineeringNeha Jaison Download
12