What happen if drug destroy all the cones in the retina?

You would lack the ability to "see" many colors. You would also lose a significant amount of your visual acuity.