Skip to main content

qds.spDeleteAssetId

Description

Deletes all QDS-related records associated with a given assetId. This includes links to check sheets, events, attribute tolerances, and data sources.

Parameters

  • @assetId (int): ID of the asset to delete.

Key Operations

  • Deletes from the following QDS tables:
    • qds.chkShtAssetLink
    • qds.chkShtEvent
    • qds.attributeTolerance
    • qds.attributeDataSource
  • Aggregates the number of rows deleted from each table.

Return Value

Returns the total number of rows deleted across all relevant tables.

Example​

-- Delete QDS records for a specific asset
DECLARE @deletedRows INT;
EXEC @deletedRows = qds.spDeleteAssetId @assetId = 42;
SELECT @deletedRows AS DeletedRows;