For the longest time, T-SQL writers have had to wrestle with ways of testing for an object’s existence so that it can either be dropped and recreated, or modified as needed. This is especially common… Testing for Object Existence: DROP … IF EXISTS