How many light years away does a Supernova have to be to destroy Earth?

For a supernova to directly destroy Earth, it would need to be less than 10 light years away. However, even if a supernova were to occur farther away, its effects on Earth's atmosphere and climate could still be substantial.