Nothing is 100% foolproof but a metal detector and armed security are pretty effective.
And that doesn't stop prisoners in prisons from killing each other.
Is that really what we want to turn our public schools into?