Not sure if you're actually talking about erasing already created memories or causing amnesia..
But loss of memory can result from brain injury or some neurological disorders. Never heard of a drug that causes a loss of memory though.
If you are talking about causing amnesia, there are the benzodiazepines, alcohol, anticholinergics, etc.
EDIT: Also, yes. I would like to know why this question was asked.