Skip to main content

qds.spDeleteAttribute

Description

Recursively deletes an attribute and all its descendants from the QDS schema, removing associated links, tolerances, and data sources.

Parameters

  • @attributeId (int): The ID of the root attribute to delete.

Key Operations

  • Builds a recursive list of attributes to delete using a CTE
  • Deletes associated records from:
    • qds.chkItemAttrLink
    • qds.attributeDataSource
    • qds.attributeTolerance
  • Nulls out parentId references for attributes being deleted
  • Deletes the attributes themselves

Return Value

Returns the total number of rows deleted from all affected tables.

Example​

-- Delete an attribute and its children recursively
DECLARE @deletedRows INT;
EXEC @deletedRows = qds.spDeleteAttribute @attributeId = 103;
SELECT @deletedRows AS DeletedRows;