qds.spDeleteItemSet

Description

Removes an item set from the QDS database along with its attribute tolerances, links, and checklist references.

Parameters

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

Key Operations

Deletes from:

• attributeTolerance
• itemSetLink
• chkShtItemSetLink
• itemSet

Return Value

Total number of deleted rows.

Code Example

-- Example: Delete an item set with ID 42
EXEC qds.spDeleteItemSet @itemSetId = 42;