Not a dam, but such a military strategy has already happened and was extremely foolish.

Intentionally breaching the dikes of the Yellow River killed nearly a million people, displaced several million more, and was a contributing factor to people turning towards the Chinese Communists and away from the KMT.