qds.spDeleteItemId

Description

Deletes all QDS data tied to a specific item ID, including tolerances, links, and events.

Parameters

• @itemId (int): ID of the item to delete.

Key Operations

Deletes from:

• attributeTolerance
• itemSetLink
• chkShtEvent
• chkShtItemLink

Return Value

Total number of deleted rows.

Code Example

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