DELETE vs TRUNCATE | DELETE Command | TRUNCATE Command | #TechPointFundamentals
Agenda:
---------
Q01. What is the difference between DELETE and TRUNCATE in SQL?
Q02. Is it true that DELETE can be rolled back, but TRUNCATE can’t be rolled back?
Q03. Is it true that DELETE can be restored back, but TRUNCATE can’t be restored back?
Q04. Is it true that TRUNCATE TABLE is non-logged?
Q05. Can you recover the deleted records from the Table?
Q06. What is LSN (Log Sequence Numbers) in SQL?
Q07. What is DELETED Table in SQL?
Difference:
-----------
1. DELETE is the DML command and TRUNCATE is the DDL command.
2. DELETE deletes records one by one, whereas TRUNCATE de-allocates pages at one go.
3. TRUNCATE resets the IDENTITY back to the SEED while DELETE does not.
4. You require delete permission on a table to use this. You require Alter table permissions to truncate a table.
5. You can use the Delete statement with the indexed views, but TRUNCATE cannot be used.
16 views
1668
548
2 months ago 00:00:36 1
X-men struggles to deafeat him!!🔥Is he inevitable?? #marvel #xmen #wolverine Xmen apocalypse
2 months ago 00:03:55 1
Flatline VS Spaceman VS The Nights | Hardwell UMF 2023 Mashup | Harddix Remake
2 months ago 00:00:33 1
Power of Magneto🔥He was not always bad #marvel #xmen #wolverine
2 months ago 00:02:06 1
[FREE FOR PROFIT] Playboi carti x Yeat new jazz type beat - “saxo“
2 months ago 05:27:20 1
70 Leetcode problems in 5+ hours (every data structure) (full tutorial)
2 months ago 00:03:33 1
Kygo x Tina Turner - What’s Love Got to Do with It (Lyrics & 432Hz)
2 months ago 00:07:55 1
Apple Watch vs Rolex Submariner | Watchfinder & Co.
2 months ago 00:12:33 1
How to make copper plating by using water Without Electricity!Science Project, Practical invention
3 months ago 00:00:48 1
یامنزل القرآن یا خالق الانسان شکر یارب🤲🕋#shorts #youtubeshorts#islamicvfx#trending I
3 months ago 00:05:42 1
DeleteMe Review: How to Remove Yourself From The Internet, Forever (2024 Guide)
3 months ago 02:43:53 1
No More Permanent Features?! Time to Explain (feat. @ReddySet and @TeddieCasts )
3 months ago 00:44:47 1
Жутко, но круто 😱 FNF - The Mixed Collection + 3 MOD’s
3 months ago 00:03:38 1
SOALEX - Move My Body | Optimus Prime vs Grimlock [4K]
3 months ago 00:53:48 1
🇷🇺 Генри Сардарян / Покушение на Трампа, увеличение численности ВС РФ и протесты в Европе.🎥🎦🎤🎙️🚀🔥💥⚡️
3 months ago 01:51:17 1
🇷🇺 ИЗОЛЕНТА Live #1599 / Израиль vs Ливан, захват Wildberries, Армения и ОДКБ, запрет самокатов.🎥🎤🔥💥
3 months ago 00:00:15 1
Brookemonk 🥰💖 vs. Cece Rose 💘😎 Dance Ciel Challenge Rate 1👆 or 2🤘 #tiktok #dance #fpy #viral
3 months ago 00:00:34 5
Why so serious? ORIGINAL vs MEME | Jonkler
3 months ago 00:03:28 1
FNF REMASTERED MIX - No More Innocence x Left Unchecked [GF Side] V2 | NMI Sonic Vs. Girlfriend
3 months ago 00:37:33 1
President Trump Initiates EO 13818 and Joe Biden Continues it!