Skip to main content

qds.spDeleteChkShtEvents

Removes all checklist events and linked checklist item events for a given checklist sheet.
- `@chkShtId` (int): ID of the checklist sheet whose events will be deleted.
- Deletes from `chkItemEvent` where `chkShtEventId` matches. - Deletes from `chkShtEvent`.
Total number of deleted rows.

Code Example​

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