Click here to Skip to main content
15,885,862 members
Search within:


Is TRUNCATE table is rolled back?
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
SQL
hi..
Is TRUNCATE table is rolled back?
Posted
Add a Solution

3 solutions

Here is a discussion about this

If you use TRANSACTIONS in your code, TRUNCATE can be rolled back. If there is no transaction is used and TRUNCATE operation is committed, it can not be retrieved from log file. TRUNCATE is DDL operation and it is not logged in log file.
http://blog.sqlauthority.com/2010/03/04/sql-server-rollback-truncate-command-in-transaction/[^]
 
Share this answer
 
Posted
Hi,
You cannot roll back a TRUNCATE TABLE statement, nor can you use a FLASHBACK TABLE statement to retrieve the contents of a table that has been truncated.
Truncate Table Discussion[^]
 
Share this answer
 
Posted
v2
You can - if you use it in a Transaction. There is a discussion of it here: http://www.sql-server-performance.com/forum/threads/how-to-rollback-truncate-operation.16968/[^]
 
Share this answer
 
Posted
Comments
thatraja 14-Nov-11 7:28am    
I thought it's impossible one
5!
Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month
Related Questions
Sql . Roll Back the Truncate valuea
Difference between truncate and delete
Rolling back transactions results in the whole thing being rolled back
how to get back data from table after truncate
Truncate table Automatically
Please help I am trying to catch exceptions in a store proc and roll back
Automatically truncated tables
truncate table or delete table data
Truncate table with foreign key constraint
roll back in SQL*plus

Advertise
Privacy
Cookies
Terms of Use
Last Updated 14 Nov 2011
Layout: fixed | fluid
Copyright © CodeProject, 1999-2024
All Rights Reserved.

Web04 2.8:2024-04-02:1

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900