Question

Possible Duplicate:
How do I delete cases?

I want to remove all evidence of a particular bug. What do I do?

Answer 1

Back up your database.

• DELETE FROM Attachment WHERE ixBugEvent IN (SELECT ixBugEvent FROM BugEvent WHERE ixBug = 123);
• DELETE FROM BugEvent WHERE ixBug = 123;
• DELETE FROM BugView WHERE ixBug = 123;
• DELETE FROM BugRelation WHERE ixBugFrom = 123;
• DELETE FROM BugRelation WHERE ixBugTo = 123;
• DELETE FROM Duplicates WHERE ixBugDupe = 123;
• DELETE FROM Duplicates WHERE ixBugDupeOf = 123;
• DELETE FROM Scout WHERE ixBug = 123;
• DELETE FROM TagAssociation WHERE ixBug = 123;
• DELETE FROM Bug WHERE ixBug = 123;

Answer 2

For Microsoft SQL users:

CREATE PROCEDURE [dbo].[DELETEBUG] @BugId AS INT AS

DELETE FROM Attachment WHERE ixBugEvent IN (SELECT ixBugEvent FROM BugEvent WHERE ixBug = @BugId)

DELETE FROM BugView WHERE ixBug = @BugId

DELETE FROM BugRelation WHERE ixBugFrom = @BugId

DELETE FROM BugRelation WHERE ixBugTo = @BugId

DELETE FROM Duplicates WHERE ixBugDupe = @BugId

DELETE FROM Duplicates WHERE ixBugDupeOf = @BugId

DELETE FROM Scout WHERE ixBug = @BugId

DELETE FROM TagAssociation WHERE ixBug = @BugId

delete FROM SUBSCRIPTIONS where ixbug = @BugId

delete FROM BUGEVENT WHERE IXBUG = @BugId

delete FROM BUG WHERE IXBUG = @BugId