qds.spDeleteChkSht

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

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

Deletes data from: - `chkItemEvent`, `chkItemAttrLink`, `chkItem` - `chkShtEvent`, `chkItemGroup`, `chkShtItemLink`, `chkShtItemSetLink` - `chkShtAssetLink`, `chkShtItemClassLink`, `chkShtToolingLink`, `alertGroupLink`, `chkShtFile`, `chkShtTrigger` - Nullifies `reTestChkShtId` if present

Total number of deleted rows.

Code Example

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