Skip to main content

qds.spDeleteItemId

Deletes all QDS data tied to a specific item ID, including tolerances, links, and events.
- `@itemId` (int): ID of the item to delete.
Deletes from: - `attributeTolerance` - `itemSetLink` - `chkShtEvent` - `chkShtItemLink`
Total number of deleted rows.

Code Example​

-- Example: Delete all records tied to item ID 99
EXEC qds.spDeleteItemId @itemId = 99;