Archives of the TeradataForum

Message Posted: Tue, 30 May 2012 @ 00:07:34 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Assuming the request has been "committed" (99.99999999% chance that it has), you are in the following territory:

* restore from backup

* reload from source.

If you are lucky, someone might have set up some auditing on the table (I've done this in the past where certain tables are subject to stringent controls and auditing). In this case the delete and the rows deleted will have been recorded and you could theoretically get the deleted data restored from there. I suspect that you would be very, very, very lucky if this was the case.

Before running a delete, it is a good idea to replace the "Delete" keyword with "select count(*) from" or "select * from" in your query. That way you can get a feel for what data is going to be affected **before** it ends up on the one way street to the bit bucket.

Glenn Mc

	<Prev	Next>		<<First	<Prev	Next>	Last>>