Delete an existing comment

Deletes one comment. Identify the comment by Id in the WHERE clause and the issue by IssueIdOrKey in WITH.

DELETE FROM Comments WHERE Id=10004 WITH(IssueIdOrKey='CS-2')