This script drops manually added statistics. By setting the @debug flag to 1, this script shows the actual statement without executing it.
You can add a table filtercriteria, by default all tables are processed. Note statistics on table [queue_messages] are ignored (you can't drop these).
NOTE: Make sure you realize the consequences if you run this script. Statistics are a base source for the optimizer. After you've dropped statistics, performance might be an issue.