You can issue the GETDELETED query to retrieve all records deleted from the live data for the time range specified. This query accepts a datetime value as a filter, as shown in the following example:
Copy
Ask AI
GETDELETED FROM <table_name> WHERE <search_condition><search_condition> ::= { <expression> { = | < | <= | > | >= } [ <expression> ] } [ { AND | OR } ... ]<expression> ::= | @ <parameter> | ? | <literal>