Tech
News
Videos
Forums
Jobs
Books
Events
More
Interviews
Live
Learn
Training
Career
Members
Blogs
Challenges
Certification
Contribute
Article
Blog
Video
Ebook
Interview Question
Collapse
Feed
Dashboard
Wallet
Learn
Achievements
Network
Refer
Rewards
SharpGPT
Premium
Contribute
Article
Blog
Video
Ebook
Interview Question
Register
Login
Difference between Truncate and Delete
WhatsApp
Venkatesan Jayakantham
12y
4.6
k
0
0
25
Blog
----- DIFF BETWEEN TRUNCATE AND DELETE
1. TRUNCATE WILL DELETE THE ENTIRE TABLE @ A STRETCH
DELETE WILL DELETE EACH RECORD
2. NO LOGGING IN TRUNCATE ... LOGGING DELETE
3. PROCESS IS TOO FAST AND WE CAN RECOVER THE DATA IN TRUNCATE
Cheers,
Venkatesan Prabu .J
Head -
www.kaashivinfotech.com
http://venkattechnicalblog.blogspot.com/
DIFF BETWEEN TRUNCATE AND DELETE
Up Next
Difference between DELETE and TRUNCATE commands
Ebook Download
View all
SQL Queries For Beginners
Read by 18.4k people
Download Now!
Learn
View all
Membership not found