Skip to main content

qds.spDeleteChkSht

Description

Deletes a checklist (chkShtId) by first deleting associated checklist items and their dependencies, followed by deletion from multiple linking and data tables.

Parameters

  • @chkShtId (int): ID of the checklist to delete.

Key Operations

Deletes data from:

  • chkItemEvent, chkItemAttrLink, chkItem
  • chkShtEvent, chkItemGroup, chkShtItemLink, chkShtItemSetLink
  • chkShtAssetLink, chkShtItemClassLink, chkShtToolingLink, alertGroupLink, chkShtFile, chkShtTrigger
  • Nullifies reTestChkShtId if present

Return Value

Total number of deleted rows.

Code Example​

-- Example: Delete a checklist sheet with ID 45
EXEC qds.spDeleteChkSht @chkShtId = 45;