| title | SET DELETED Command | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 01/19/2017 | |
| ms.prod | sql | |
| ms.prod_service | connectivity | |
| ms.reviewer | ||
| ms.technology | connectivity | |
| ms.topic | conceptual | |
| helpviewer_keywords |
|
|
| ms.assetid | 6b5e0086-156d-471d-8e7f-6c5fa9686cd5 | |
| author | David-Engel | |
| ms.author | v-daenge |
Specifies whether records marked for deletion are processed and whether they are available for use in other commands.
SET DELETED ON | OFF
ON
(Default for the driver; the default for Visual FoxPro is OFF.) Specifies that commands that operate on records (including records in related tables) using a scope ignore records marked for deletion.
OFF
Specifies that records marked for deletion can be accessed by commands that operate on records (including records in related tables) using a scope.
Queries that use DELETED( ) to test the status of records can be optimized using Visual FoxPro Rushmore technology if the table is indexed on DELETED( ).
Important
SET DELETED is ignored if the default scope for the command is the current record or if you include a scope of a single record. INDEX always ignores SET DELETED and indexes all records in the table.