Home

Select current and deleted data

Rollback data

It is often useful to retain and access deleted data to maintain references, joins, etc. This article demonstrates how to do this with SQL Retroview.

From .NET code

Use DataInterface.SelectCurrentAndDeleted, as demonstrated in the following code sample. For more information, see the documentation.

    DataTable result = dataInterface.SelectCurrentAndDeleted(
        "tblCompany", "CompanyID=12");

From native SQL

Simply select the data from the desired table. Deleted rows will be included.

    
    SELECT * FROM tblCompany