pears.RemoveDeletedQuestion

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
Original SQL

CREATE PROCEDURE "pears"."RemoveDeletedQuestion"()
/* Application Maintained Function / Procedure - DO NOT EDIT*/
BEGIN
  DELETE FROM "DeletedTag" WHERE "datediff"("day","WhenDeleted",CURRENT DATE) > 200;
  DELETE FROM "DeletedTagChoice" WHERE "datediff"("day","WhenDeleted",CURRENT DATE) > 200;
  DELETE FROM "DeletedTagValue" WHERE "datediff"("day","WhenDeleted",CURRENT DATE) > 200;
  DELETE FROM "DeletedTagCompliance" WHERE "datediff"("day","WhenDeleted",CURRENT DATE) > 200;
  DELETE FROM "DeletedCriterion" WHERE "datediff"("day","WhenDeleted",CURRENT DATE) > 200;
  DELETE FROM "DeletedDocumentTag" WHERE "datediff"("day","WhenDeleted",CURRENT DATE) > 200;
  DELETE FROM "DeletedDepartmentTag" WHERE "datediff"("day","WhenDeleted",CURRENT DATE) > 200;
  DELETE FROM "DeletedReferenceMasterQuestion" WHERE "datediff"("day","WhenDeleted",CURRENT DATE) > 200;
  IF EXISTS(SELECT * FROM "sys"."systable" WHERE "table_name" = 'DeletedIQXNetTagGroupMember') THEN
    DELETE FROM "DeletedIQXNetTagGroupMember" WHERE "datediff"("day","WhenDeleted",CURRENT DATE) > 200
  END IF
END
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."RemoveDeletedQuestion" IS 
{CREATE PROCEDURE RemoveDeletedQuestion 
 
/* Application Maintained Function / Procedure - DO NOT EDIT*/
 
( )
BEGIN
  DELETE FROM DeletedTag WHERE datediff(DAY,WhenDeleted, CURRENT DATE) > 200;
  DELETE FROM DeletedTagChoice WHERE datediff(DAY,WhenDeleted, CURRENT DATE) > 200;
  DELETE FROM DeletedTagValue WHERE datediff(DAY,WhenDeleted, CURRENT DATE) > 200;
  DELETE FROM DeletedTagCompliance WHERE datediff(DAY,WhenDeleted, CURRENT DATE) > 200;
  DELETE FROM DeletedCriterion WHERE datediff(DAY,WhenDeleted, CURRENT DATE) > 200;
  DELETE FROM DeletedDocumentTag WHERE datediff(DAY,WhenDeleted, CURRENT DATE) > 200;
  DELETE FROM DeletedDepartmentTag WHERE datediff(DAY,WhenDeleted, CURRENT DATE) > 200;
  DELETE FROM DeletedReferenceMasterQuestion WHERE datediff(DAY,WhenDeleted, CURRENT DATE) > 200;
  IF EXISTS (SELECT * FROM sys.systable WHERE TABLE_NAME= 'DeletedIQXNetTagGroupMember') THEN
     DELETE FROM DeletedIQXNetTagGroupMember WHERE datediff(DAY,WhenDeleted, CURRENT DATE) > 200
  END IF;
END
}