DELETE vs TRUNCATE, DELETE Command, TRUNCATE Command, , Tech Point Fundamentals

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 cant be rolled back Q03. Is it true that DELETE can be restored back, but TRUNCATE cant be restored back Q04. Is it true that TRUNCATE TABLE is nonlogged 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 deallocates 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.