Hyphen in my computer's name causing T-SQL error
When you have special characters in a name put []'s around it to let SQL know that it's an identifier.  This is also how you manage special characters.

So in your case

Drop Login [John-PC\John]